Focal Point
[SOLVED]How to convert date format from HYYMDs to another date format- MDYYX

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

May 20, 2016, 07:11 AM
info4pal
[SOLVED]How to convert date format from HYYMDs to another date format- MDYYX
Hi,

I need the date format which is in HYYMDS format and of length - 17 to be converted to this format :

Old format in the output for a date column(ABC) is 2016/05/19 22:00:00

I need the output to be displayed as 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!

This message has been edited. Last edited by: info4pal,
May 23, 2016, 02:27 PM
jcannavo
When you print it why don't you just set the format as HMTDYYIA?

I.E.
 
TABLE FILE MY_REPORT
PRINT
DATE_FIELD_HERE/HMTDYYIA
ON TABLE PCHOLD FORMAT HTML
.
.
.
  



JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
May 23, 2016, 02:41 PM
Ricardo Augusto
info4pal,

take a look here if you have $97 to spend.http://www.aviter.com/keysheet/home/dates-book/

This message has been edited. Last edited by: Ricardo Augusto,


WebFOCUS 8.1.05 / APP Studio
May 23, 2016, 02:50 PM
jcannavo
I'm sure Vivian would appreciate your post Ricardo Smiler. Do you own the book, if so how often do you use it?


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
May 23, 2016, 02:53 PM
Ricardo Augusto
I haven´t it yet.
I own the WebFOCUS_Keysheet_56a1132003103.pdf am I use it almost every day.


$1 is around R$3.6 ( Brazil´s economy is bad atm).


WebFOCUS 8.1.05 / APP Studio
May 23, 2016, 03:10 PM
GavinL
I bought the $22 version, for v7, and the book is more confusing than the date conversions.. Someone had to write a book on how to convert dates for a language, then that means IBI should look at making this a bit more simple.

http://www.amazon.com/WebFOCUS...-DATES/dp/B000NM10IG

http://www.ebay.com/itm/WebFOC...-FOCUS-/221558313982



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
May 23, 2016, 03:41 PM
jcannavo
quote:
Someone had to write a book on how to convert dates for a language, then that means IBI should look at making this a bit more simple.


I agree!


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
May 23, 2016, 05:45 PM
eric.woerle
When I started out, one of the guys I worked with had 1001 ways to work with dates, and it was great to use. Now I don't miss it. I can find everything I need anyways.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
May 24, 2016, 01:28 AM
info4pal
Hi,

Thanks a lot everyone for the suggestions and solution/s.
It helped me a lot! Smiler

Regards,
IP
May 24, 2016, 08:58 AM
jcannavo
Hi IP,

If you are satisfied with the answers and feel you are set please edit the title of your original post to include [CLOSED] or [SOLVED].

Thanks!


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
May 24, 2016, 09:01 AM
George Patton
I've retired from writing WF code after 30 years(training to be a flight instructor now), but I frequently consulted the "Almost 1001 ways to work with dates" book. It's a useful tool, but I was often frustrated by the design of the book. It has too much text crammed onto every page and the illustrations are often on a different page than the accompanying explanations. Printing the book in a larger format would seem to be part of the answer, as well as fleshing out the explanations a lot more.

Just my 2 cents ....


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
May 24, 2016, 10:02 AM
Squatch
quote:
Originally posted by jcannavo:
quote:
Someone had to write a book on how to convert dates for a language, then that means IBI should look at making this a bit more simple.


I agree!

I think companies and organizations that use WebFOCUS would be justified in hiring a full-time WebFOCUS date specialist.

And no, I wouldn't want that job!


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs