Hi,

I need the date format which is in HYYMDS format to be converted to this format :

2016/05/19 22:00:00 to May 19, 2016 10:00:00 PM.

Tried using CHGDAT function but not getting the desired output.

Could anyone please let me know how to do this?

Thanks a lot in advance!

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

HYYMDS is a DateTime format. AS such it is easily changed to another DateTime forma via simple equality. For
NewDate/HMTDYYSa = HYYMDS_field ;
produces May 19, 2016 10:00:00pm (your example - full month name)
or
NewDate/HMtDYYSa = HYYMDS_field ;
produces May 19, 2016 10:00:00pm (your example - short month name)

You can also do this directly in a print column.
The presumes that the HYYMDS format is the "Actual" format.

Hi,

Thanks a lot Richardo and John for the solution.
It helped me and I was able to get the required date format.

Regards!