AnsweredAssumed Answered

UK and USA Date formatting

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


UK and USA Date formatting


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



"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.