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!

Uppercase month field

Status
Not open for further replies.
lilal111

lilal111

Technical User
Joined
Sep 16, 2008
Messages
18
Location
CA
I am trying to use the uppercase command with a datefield. I am trying to capitalize the Feb portion below. Could someone help me out?


Example.... 08 Feb 09
 
Sort by date Sort by votes
If you used the Format Object to format the date field, then

uppercase({table.datefield})

Otherwise

uppercase(totext({table.datefield},"dd MMM yy"))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dev1212
  • Locked
  • Question Question
Update database field size
Replies
5
Views
631
dev1212
dev1212
Katerine
  • Locked
  • Question Question
Concatenated field and text just appearing as empty brackets/boxes
Replies
2
Views
424
Katerine
Katerine
netchie
  • Locked
  • Question Question
Dynamic Parameters Wont Show as List After Conversion due to Missing Fields and SQL Query in Command
Replies
0
Views
281
netchie
netchie
hsandwick
  • Locked
  • Question Question
Crystal field size - conversion in BOXI3.1 Infoview too long
Replies
3
Views
341
hilfy
hilfy
dninus
  • Locked
  • Question Question
How to display multiple grouping fields on one page
Replies
2
Views
506
anandviru
anandviru

Part and Inventory Search

Sponsor

Back
Top