Return A Date Format

ricky76

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

garak

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

ara3n

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

zeninoleg

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

Cheers for your help

ara3n

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