AnsweredAssumed Answered

Date/Region format mess

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

Hi,

 

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

 

MTIA

Outcomes