Return A Date Format

ricky76 · 2006-11-07

I have a date of 30042006. I want to return this as Apr 30,2006. Any ideas how i can do this?

garak · 2006-11-07

For the name of the month, you can use the date table

ara3n · 2006-11-07

Mydate := 04302006D;
mystr := format(Mydate,0,'<Month Text> <Day>, <Year4>');
message(mystr);

zeninoleg · 2006-11-07

OldDate := '30042006';
EVALUATE(DayVar, COPYSTR(OldDate, 1,2));
EVALUATE(MonthVar, COPYSTR(OldDate, 3,2));
EVALUATE(YearVar, COPYSTR(OldDate, 5,4));

MESSAGE('%1', FORMAT(DMY2DATE( DayVar,MonthVar,YearVar), 0, '<Month Text, 3> <Day>, <Year4>'));

This should work

ricky76 · 2006-11-07

Cheers for your help

ara3n · 2006-11-07

you are welcome. You should take a look at developer manual.

Return A Date Format

Comments

Categories