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

Date Format

P: 5
How can I change the month format in my report from October 2007(small letter) to OCTOBER 2007(Capital Letter), I am using the command Format$([DUEDATE],"mmmm yyyy",0,0), please suggest the correct command for this....
Sep 19 '07 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
How can I change the month format in my report from October 2007(small letter) to OCTOBER 2007(Capital Letter), I am using the command Format$([DUEDATE],"mmmm yyyy",0,0), please suggest the correct command for this....
Hi, there.

You are looking for UCase() function.
e.g.
ucase(format(#1/1/1#, "dd mmmm yyyy"))

And I strongly recommend you not to use "$" variants of string functions. They exist for backward compatibility only and supposed to be ceased in near future.

Regards,
Fish
Sep 19 '07 #2

P: 5
It really helped me, Thanks a Lot.........
Sep 19 '07 #3

FishVal
Expert 2.5K+
P: 2,653
It really helped me, Thanks a Lot.........
You are welcome.

Best regards,
Fish
Sep 19 '07 #4

Post your reply

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