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 ??

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

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