Access date problems - TechRepublic
General discussion
October 2, 2003 at 07:08 AM
munrrob

Access date problems

by munrrob . Updated 22 years, 9 months ago

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?

This discussion is locked

All Comments