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 strongm 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
145
dev1212
dev1212
Katerine
  • Locked
  • Question
Concatenated field and text just appearing as empty brackets/boxes
Replies
2
Views
99
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
63
netchie
netchie
hsandwick
  • Locked
  • Question
Crystal field size - conversion in BOXI3.1 Infoview too long
Replies
3
Views
56
hilfy
hilfy
dninus
  • Locked
  • Question
How to display multiple grouping fields on one page
Replies
2
Views
100
anandviru
anandviru

Part and Inventory Search

Sponsor

Back
Top