By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 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

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

Post your reply

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