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,
Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
WebFOCUS 8.1.05 / APP Studio
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)
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.
WebFOCUS 8.0.2, FOCUS since 1977 - John@Aviter.com
PDF , Excel, FOCUS, Author of the Keysheets and Dates book.
Thanks a lot Richardo and John for the solution.
It helped me and I was able to get the required date format.
|Powered by Social Strata|