Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format date to upper case

Status
Not open for further replies.
HomeGrowth

HomeGrowth

Technical User
Aug 19, 2004
76
US

I am try to format the month in upper case. For example, I would like to see 01JAN05 instead of 01Jan05 in ddmmmyy. Please advice and Thanks!
 
Sort by date Sort by votes
Try:

UCase(Format(Date, "ddmmmyy"))

John Borges
 
Upvote 0 Downvote
jbpez,

You are super! my job is done to day and I am going to watch the superbowl. Thanks again!

Tt
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
291
sxschech
sxschech
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
421
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
245
dhookom
dhookom
iamchemist
  • Locked
  • Question
Push To WORD?
Replies
3
Views
371
iamchemist
iamchemist
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
2K
EwaFAMA
EwaFAMA

Part and Inventory Search

Sponsor

Back
Top