Using UK format (dd/mm/yyy) dates, I’m performing a simple Find, i.e.
Enter Find Mode
Set Field [PPL to PPX::PPX_DateOfFirstAttendance;”05/12/2011”]
When doing this in a local version of the file, it’s fine. But when the file is shared via FM Server (11), the date is read as US format, i.e. records with “12/05/2011” are found.
I’m sure this must be something simple, and I’ve gone over and over the field definitions, the system settings on both machines, etc., but I’m really at a loss. (In File Options, I have "Always use current system settings" selected, date fields are defined as date fields.)
If you could point me in the right direction, I’d be ever so grateful.