Focal Point
[SOLVED]Change the date format from HYYMDS to another date format

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6327044286

May 20, 2016, 09:42 AM
info4pal
[SOLVED]Change the date format from HYYMDS to another date format
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,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
May 20, 2016, 09:52 AM
Ricardo Augusto
http://documentation.informati.../source/datetime.htm


WebFOCUS 8.1.05 / APP Studio
May 20, 2016, 11:19 AM
John W Price
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.



WebFOCUS 8.0.2, FOCUS since 1977 - John@Aviter.com
PDF , Excel, FOCUS, Author of the Keysheets and Dates book.
www.Aviter.com
May 23, 2016, 02:04 AM
info4pal
Hi,

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

Regards!