Full Version: change date format
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
him5002
Hi,
How do i change the format of a date from 1/12/2008 to just 1/2008 in a query? I have a whole field of dates and need to change the format of all of them. Thanks in advance for your help!
niesz
I'll assume you just want to change they way they display, and not update the original values.

If so, try:

Format([YourDateField),"m/yyyy")
him5002
Ok, great, that worked! Thanks for your help!
niesz
NP.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.