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

John, 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> How can I ensure that date is always assigned in dd/mm/yyyy format to a
> date filed, in an update query?
>
> Thanks
>
> Regards