By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,659 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,659 IT Pros & Developers. It's quick & easy.

Date format in update query

P: n/a
Hi

How can I ensure that date is always assigned in dd/mm/yyyy format to a date
filed, in an update query?

Thanks

Regards
Jun 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Access does not store dates in a specific format. The format is applied at
display time, and depends on the user's Regional Settings (in the Windows
Control Panel.)

So perhaps your question is, "How can I ensure that Access understands the
dates in the query, and stores the correctly when the Update query
executes?"

I also live in a d/m/y country, and in 15 years of working with Access have
found 3 cases where Access is likely to misunderstand our dates. Details in:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

If the dates are calculated ones, typecasting them in the query can also
help:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:yt******************************@pipex.net...

How can I ensure that date is always assigned in dd/mm/yyyy format to a
date filed, in an update query?

Jun 23 '06 #2

P: n/a
* John:
Hi

How can I ensure that date is always assigned in dd/mm/yyyy format to a date
filed, in an update query?

Thanks

Regards


If you are updating a date field, there is no reason to consider the
format. Dates are always stored as a numeric value. It's only when you
display the dates that the format is applied.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Jun 23 '06 #3

P: n/a
in the query string use format(mydate,"mm/dd/yyyy")
that will ensure that the query understands your date.
Alec

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:yt******************************@pipex.net...
Hi

How can I ensure that date is always assigned in dd/mm/yyyy format to a date filed, in an update query?

Thanks

Regards

Jun 25 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.