Date Problem

[darrenN]

I' m importing a tab seperated text file, it contains dates which look like this;

10/10/00 when I import the file the field that holds this value (which is a date field) shows the date with the year as a 4 figure number, but instead of showing the year as 2000 it shows it as 1900. Seems strange? Is this a FileMaker error and is there a solution to it ??

[WBlanchard]

I've had this problem too. I don't know the exact cause, but, it appears to be the result of importing a 2 digit year format.

The fix I've had to use, is to open the import file in Excel and change the date format to mm/dd/yyyy. This should give you the 2000 date, and then you can import it into FMP.

HTH

[Chuck]

If you don't have Excel or some other program, you can use the following script to fix the data:

Show All Records

Go to Record/Request/Page [ First ]

Loop

If [ Year( ImportedDate ) = 1900 ]

Set Field [ ImportedDate, Date( Month( ImportedDate), Day( ImportedDate ), 2000 ) ]

End If

Go to Record/Request/Page [ Next, Exit after last ]

End Loop