Date format in Access

  • Thread starter Thread starter Derick Reinecke
  • Start date Start date
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
 
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.
 
Back
Top