Hi everybody
When I use the Date Syntax: =Format$([Date_Field],'mmmm yyyy'), the month returns in Small letters. eg., January 2010. I want the month to return in all capitals as JANUARY 2010. How to do this?
Thanks.
Hi everybody
When I use the Date Syntax: =Format$([Date_Field],'mmmm yyyy'), the month returns in Small letters. eg., January 2010. I want the month to return in all capitals as JANUARY 2010. How to do this?
Thanks.
Try:
UCase(Format([Date_Field],"mmmm yyyy"))
Thanks a lot. It worked.
You're welcome. Glad I could help.