Date problem

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
FRED_EMMERICH_(Guest)
Posts: 170
Joined: Tue Oct 10, 2017 12:44 pm

Date problem

Post by FRED_EMMERICH_(Guest) » Fri Aug 03, 2001 7:03 pm

How can I get a date field like : January 1,2001 to be all upper case? If I create a calculated field where I do DTOC(), all I get is 1/1/2001.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Date problem

Post by kfleming » Mon Aug 06, 2001 7:17 am

You could use expression:____UPPER(CMONTH(datefield))+str(day(datefield),3)+","+str(year(datefield),4)____Kathleen__R&R Support

Post Reply