General discussion

Locked

Access date problems

By munrrob ·
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 conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Access date problems

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

Collapse -

by munrrob In reply to

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?

Collapse -

by DKlippert In reply to Access date problems

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

Collapse -

by munrrob In reply to
Collapse -

by munrrob In reply to Access date problems

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums