When entering the following:
?Format(DateAdd(“d”,-0, #10/09/03#), “dd/mm/yy”)
The following is returned:
09/10/03
The month and day have been transposed despite the system being set to UK timezone and the regional setting for short dates being dd/mm/yy. Any ideas as to what is causing this?