Focal Point
[SOLVED] Convert A8 to YYMD format

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

July 12, 2010, 04:48 PM
vkrugman
[SOLVED] Convert A8 to YYMD format
HI! I have been trying to make this conversion :

20100712(A8) --> 2010/07/12 (YYMD format)
Please help

This message has been edited. Last edited by: Kerry,


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
July 12, 2010, 05:05 PM
njsden
Search the forum and/or documentation for the DATECVT function.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
July 12, 2010, 05:32 PM
Darin Lee
You don't even need DATECVT - but this is a VERY basic question that has many easy to find examples.
DATE1/A8YYMD=DATE;

Then if you need straight smart date (for further calculation as opposed to a display only)

DATE2/YYMD=DATE1;


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
July 12, 2010, 05:41 PM
Waz
If this date is being read from a file with TABLE, then change the USAGE to YYMD, and leave the ACTUAL as A8.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

July 13, 2010, 03:10 AM
GamP
And then there's also the (remote) possibility that it concerns Dialog Manager.
Anyway, I think it has been said already many times before, there is this wondeful little booklet that deals with any and all thing that have to do with date issues. It's only 25$ and it is worth every penny of it. You can order it from ibi's documentation website.
Book title: (Almost) 1001 Ways to Work With Dates for WebFOCUS 7.1 - 7.1.4
Book DN: 9400251.1106


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
July 13, 2010, 10:17 AM
vkrugman
Thank you, All
I used this function:
COMP_DT1/YYMD = DATECVT(COMP_DT, 'A8YYMD', 'YYMD');


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000