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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Date format in query export. 4
Date Function in query 3
Access not recognizing Date Format 3
Changing date fotmats & calculating date - HELP 5
Convert Date 3
date mismatch in query..do not know how to solve 3
Date() update format 5

Back
Top