Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Title:
Excel date formatting
Hi all
Does anyone have program that can convert / format dates / datetimes like Excel does?
I know I can ...
LPARAMETERS tuDateOrTime
RETURN ;
RIGHT("00"+ALLTRIM(STR(MONTH(m.tuDateOrTime))),2)+"/"+;
RIGHT("00"+ALLTRIM(STR(DAY(m.tuDateOrTime))),2)+"/"+;
ALLTRIM(STR(YEAR(m.tuDateOrTime)))
But something like transform(date(),"MMM-DD-YYYY") to get Feb 10, 2003 seems easier than the current options.
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only