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