Date format in Access

D

Derick Reinecke

Hi,

In a query, I enter a date. I need to format this to Date/Time format
(not just the correct text format e.g mm/dd/yyyy) Any suggestions?

Thanks

Derick
 
A

Allen Browne

If you are talking about an unbound text box, setting its Format property to
"Short Date" or similar helps Access understand the intended data type.

For more information, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
The article explains how to avoid the 3 cases where Access misunderstands
your date format.
 
Top