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.