AnsweredAssumed Answered

Canadian vs US Dates

Question asked by RBCohen on Oct 16, 2014
Latest reply on Oct 19, 2014 by philmodjunk

Title

Canadian vs US Dates

Post

I am importing data from OpenOffice Calc ("Excel"). The dates are set as Canadian DD/MM/YYYY 06/01/2014 = Jan 06 2014. I set FileMaker to DD/MM/YYYY but it's reading as US Date  = June 01 2014 while showing 06/01/2014 (when I click on the field and the Calendar pops up)

 

Using FileMaker Pro Advanced 11.0v4

Outcomes