AnsweredAssumed Answered

Date/Region format mess

Question asked by jlisburn on Nov 19, 2012
Latest reply on Apr 20, 2014 by jlisburn



I've got myself into a pickle with Language/Regional/Date formats.


When my Lion server was delivered its was set as Canadian and this outputs the date format: YYYY-MM-DD which is what the Candian Government uses but no other organization uses. In practical terms everyone uses MM/DD/YYYY.


I started building my solution partially on the server only to find my error when I try to use Dates in Calcs. My laptop is set as US and now I have a mish-mash of date format types.


2013-10-10 - 11/19/2012 gives me '?'


Does anyone know of a way to correct these other than removing all the date fields and recreating them


My own fault I realize; I just wish I'd realized it earlier