Date problem
-
- Posts: 170
- Joined: Tue Oct 10, 2017 12:44 pm
Date problem
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.
=> RE: Date problem
You could use expression:____UPPER(CMONTH(datefield))+str(day(datefield),3)+","+str(year(datefield),4)____Kathleen__R&R Support