AnsweredAssumed Answered

Date formats and Find on FM Server

Question asked by davehob on Oct 15, 2012
Latest reply on Oct 18, 2012 by mikebeargie

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”]
Perform Find


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.