him5002
Jun 4 2008, 09:08 AM
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
Jun 4 2008, 09:11 AM
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
Jun 4 2008, 09:27 AM
Ok, great, that worked! Thanks for your help!
niesz
Jun 4 2008, 09:27 AM
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.