Could someone please tell me how to reformat a date?

-SET &PRD_END_DT = &PRD_END_DT;

Returns: 20120630 00:00:00

I would like for it to NOT return the 00:00:00

Thank you,

This message has been edited. Last edited by: Kerry,

I think I may have found my answer using HDATE but havent gotten it to work yet ... any tips are appreciated

Do you just want to get rid of the time component at a dialog manager level ?

Then you can use GETTOK or just an EDIT/MASK and keep the first 8 characters.

-SET &DATE_PART = HCNVRT(HINPUT(&PRD_END_DT.LENGTH, &PRD_END_DT, 8, 'HYYMDS'), '(H8)', 8, 'A8');
This will check te validity of the date entered and return 0's if invalid and the yymd part if valid. No slash or - signs.

Thank you!