By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Date Format

P: 5
One of my Access report it is coming " REPORT FOR THE MONTH OF October 2007" actually I want the October in Capital Letter like "REPORT FOR THE MONTH OF OCTOBER 2007", I am using =Format$([DUEDATE],"mmmm yyyy",0,0) command, please suggest the alternate command for this.
Sep 19 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Try:

Expand|Select|Wrap|Line Numbers
  1. =UCase(Format$([DUEDATE],"mmmm yyyy",0,0))
Regards,
Scott
Sep 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.