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.
it's a hack, but you can use an if statement in your set field to trap for filemaker server
if (get(applicationVersion) = "Runtime" ; "12/05/2011" ; "05/12/2011" )
Not sure what's up with the server date format...