Date format in update query

[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

[Allen Browne]

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?

[Randy Harris]

* 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.

[Paradigm]

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