December 18, 2014, 04:05 AM
B_Bdate conversion
I need to convert dynamic date variable &CUR_SAT_DT format MDYY to format YYMD.
December 18, 2014, 05:50 AM
jvbTry using EDIT function followed by concatenating in desired format.
December 18, 2014, 06:34 AM
Ram Prasad ETry 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_MetaDateshttp://www.informationbuilders...r/ParameterDatePrintDecember 18, 2014, 07:18 AM
Wep5622Or use the DATECVT function.
December 26, 2014, 03:19 PM
VivianYou 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.comVivian
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