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 Chris Miller 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
Sep 16, 2008
18
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
Update database field size
Replies
5
Views
191
dev1212
dev1212
Katerine
  • Locked
  • Question
Concatenated field and text just appearing as empty brackets/boxes
Replies
2
Views
147
Katerine
Katerine
netchie
  • Locked
  • Question
Dynamic Parameters Wont Show as List After Conversion due to Missing Fields and SQL Query in Command
Replies
0
Views
79
netchie
netchie
hsandwick
  • Locked
  • Question
Crystal field size - conversion in BOXI3.1 Infoview too long
Replies
3
Views
68
hilfy
hilfy
dninus
  • Locked
  • Question
How to display multiple grouping fields on one page
Replies
2
Views
139
anandviru
anandviru

Part and Inventory Search

Sponsor

Back
Top