1 Reply Latest reply on Oct 18, 2012 8:36 AM by mikebeargie

    Date formats and Find on FM Server

    davehob

      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.

       

      Dave.