Date Format

[Henry]

Hi there, just want to ask some question about the data format, now i found that if i key in the date with 2 digit year, like 93, if i let the field show it into 4 digit year, it will become 2093 and not 1993. If that any way to fix it?

Regards

Henry

[Lee Smith]

Hi Henry,

Use a four digit year for formatting your dates.

To correct those dates already in your file, you can do a replace.

In version 6, you can do this by using the new Find and Replace feature (i.e. put your cursor in the field with the dates, Go to Menu - Edit - Find/Replace) Find = 2093 Replace = 1993.

In earlier versions, you have to use the Replace function. Menu - Records - Replace (Cmd = on a Mac). In the dialog box, check the box "by calculated result" and then use this calculation

Substitute(YourDateField, "2093", "1993")

By the way, use a copy of your files, as this is not Undo-able.

Lee