![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Guru |
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, | ||
|
Platinum Member |
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 | |||
|
Guru |
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 | |||
|
Platinum Member |
I'm sure Vivian would appreciate your post Ricardo ![]() JC WebFOCUS Dev Studio / App Studio 8.2.01 Windows 7 | |||
|
Guru |
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 | |||
|
Master |
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 | |||
|
Platinum Member |
I agree! JC WebFOCUS Dev Studio / App Studio 8.2.01 Windows 7 | |||
|
Master |
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 | |||
|
Guru |
Hi, Thanks a lot everyone for the suggestions and solution/s. It helped me a lot! ![]() Regards, IP | |||
|
Platinum Member |
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 | |||
|
Master |
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 | |||
|
Master |
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 | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|