Date Format

[Dima]

When I write Date() in a report it takes it in the format mm/dd/yyyy.
I need it to be in the format dd/mm/yyyy.

How do I do that?

 

[ColinEssex]

Check the regional settings of the PC

It's probably set to English USA instead of English UK

Col

 

[Fizzio]

To make sure that it formats the same on every computer, instead of Date(), use

Format(Date(),"dd/mm/yyyy") then it will format the date this wat irrespective of the Local PC's settings.