Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Change the date format from HYYMDS to another date format
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Change the date format from HYYMDS to another date format
 Login/Join
 
Guru
posted
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
 
Posts: 270 | Registered: October 30, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 40 | Registered: April 19, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
Hi,

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

Regards!
 
Posts: 270 | Registered: October 30, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Change the date format from HYYMDS to another date format

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.