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 Rhinorhino 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
Joined
Aug 19, 2004
Messages
76
Location
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 Question
How to Format a date on a report
Replies
1
Views
756
sxschech
sxschech
breezett93
  • Locked
  • Question Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
1K
dhookom
dhookom
caykamanj1966
  • Locked
  • Question Question
Search by Date and Some Text
Replies
9
Views
829
dhookom
dhookom
iamchemist
  • Locked
  • Question Question
Push To WORD?
Replies
3
Views
848
iamchemist
iamchemist
EwaFAMA
  • Locked
  • Question Question
ACCESS - Adding image from URL to the report
Replies
11
Views
6K
EwaFAMA
EwaFAMA

Part and Inventory Search

Sponsor

Back
Top