Formatting dates (months)

UCLA Lorna

Registered User.
Local time
Today, 02:35
Joined
Mar 8, 2005
Messages
32
I want the date 'August 15, 2007' to display as 'August 2007'. Suggestions?
 
Format([FieldName],"mmmm yyyy")
 
Thank you - that was too easy!

OK spoke too soon - it worked in a database in the 2000 version, but not in the 2003 version. Is there something different?
 
Last edited:
No; I just tested in 2003 and it worked fine. Did you get an error, or ??
 
It occurs to me that it could be a reference problem. Open the VBA editor on the 2003 machine and go into Tools/References. See if any of the checked references at the top say "MISSING". If so, uncheck it, recheck it, close and open Access and see if that fixes the problem. If none are MISSING, check any reference; close and open Access; then uncheck it again. This will force Access to relink the libraries.
 

Users who are viewing this thread

Back
Top Bottom