What version of FileMaker?
There's a bug with some versions where you have to change locality settings and preferences, then save a clone of the database file and use the clone.
After writing that, I checked my info in the Known Bugs List, the only entry that I find that matches this description is a case where the date is entered into a TEXT field. Sure it's of type date?
FM adv 11 v4
is it defo a date field. LEt me do the clone thing and see if that helps.
That Clone solution seems to have fixed it. However, Is there any easy way to import all records as I have lots of tables and records to import which can be a lengthy process!
Not really. If it's something you might need to do again, you can script it, but as a 'one time fix' that doesn't really save you any time.