Web Development

Ask something
Discussion Locked

Access date problems

0 helpful
5 replies

by munrrob

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

5 replies

by sgt_shultz

wild guess. i believe your formatting is being ignored because something is wrong with the syntax...what happens if you remove the last quote mark, so the end of the formula like this:
"dd/mm/yy

by munrrob

Thanks. The format is being ignored. By removing the last quote mark I get an error. What I need to know is why is the format being ignored?

by dklippert

Regardless of how you format dates, Access stores the number in US format.
See if this format mask works:

"mm\/dd\/yyy"

Allen Browne has some information on International Dates in Access at:

http://tinyurl.com/pg7u

This discussion is closed to new replies.