Focal Point
date conversion

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

December 18, 2014, 04:05 AM
B_B
date conversion
I need to convert dynamic date variable &CUR_SAT_DT format MDYY to format YYMD.


WebFOCUS 7.6
Windows, All Outputs
December 18, 2014, 05:50 AM
jvb
Try using EDIT function followed by concatenating in desired format.


WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
December 18, 2014, 06:34 AM
Ram Prasad E
Try below code.
-SET &CUR_SAT_DT=05252012;
-RUN
TABLE FILE EMPLOYEE
PRINT
FIRST_NAME
COMPUTE D_FMT_1/MDYY=&CUR_SAT_DT;
COMPUTE D_FMT_2/YYMD=D_FMT_1;
END

Also refer to below techniques.
http://www.informationbuilders...elopers/WF_MetaDates
http://www.informationbuilders...r/ParameterDatePrint


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
December 18, 2014, 07:18 AM
Wep5622
Or use the DATECVT function.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
December 26, 2014, 03:19 PM
Vivian
You will find all you need to know about dates and their conversions in the (almost) 1001 Ways to Work with Dates - covers through release 8

Both the ebook and hard copies provide a ton of information and examples! www.aviter.com

Vivian


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com