AnsweredAssumed Answered

UK and USA Date formatting

Question asked by jonnyt on Mar 21, 2010
Latest reply on Mar 21, 2010 by jonnyt

Title

UK and USA Date formatting

Post

I started a database for a client using a customer management template.

 

We are based in the UK.

 

When the system displays a date field it show correctly in UK format DD/MM/YYYY

 

I have a calculation that uses that is used to input an entry in a description field

 

e.g.

"Date Entry Added" & Get(CurrentDate)

 

When you display the contents of the field it displays as "Date Entry Added 02/30/2010"- in usa format.

 

 

Is there any way of forcing UK date formats across the entire database? I have encountered serveral problems with dates with this system that Ive been developing for a client.

Outcomes