Hi, forgive what must seem a newbie question, but this is driving me insane!

In FM4 I had a load of databases which quite happily worked with dates in the European format (dd/mm/yyyy) instead of the illogical US system (mm/dd/yyyy). But having converted to FM Pro 6, all my dates have reverted to the US format!

I have looked in Preferences to reset to UK defaults - there is nothing there. I have tried Field Format - no, nothing there either. It will allow me to format the date field any way I like (e.g. like the OS X System Preference pane) AS LONG AS it is in the US sequence.

Then I tried a Custom format, where I specified the date should be "28" "-" "01" "-" "2008" : that was fine, FM allowed me to do that. The problem comes when I actually come to enter data, e.g. "28 01 2008", it tells me "the date must be a valid date.... and must look like 12 25 1997".

And before you ask - yes, I have my Mac set to UK in the International pane, and there is a little Union flag in my menu bar.

So before I start gibbering and they call for the men in white coats, what on earth can I do to persuade FM6 to be more like FM4 and happily work with UK date formats?

You have to change the Setting for the time too.

International >> Formats >> Region >> United Kingdom.

Also, in order to have it change from US to UK now, you will have to save a copy of it "No Records", and import your data.

HTH

Lee

Hi - thanks

I have International > Formats > Custom set up, as per an Apple Forums Discussion thread, in order to show the seconds ticking off in the time in the menu bar. Has that caused this problem do you think?

If it has, do I now have to choose between showing the time with seconds, or UK date formats in FM ? That would be a shame...