Focal Point
[SOLVED] Convert Legacy Date Format

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

February 11, 2014, 12:56 PM
AAranha
[SOLVED] Convert Legacy Date Format
Is it possiblt to convert a date format from 02/14/2014 to 14/02/2014.

Currently I have to following set up to pick up the weekly date range:
-SET &YESTERDAY = AYMD(&YYMD, -1, 'I8YYMD');
-SET &YESDAY = EDIT(&YESTERDAY, '9999/99/99');
-SET &TODAY1_5 = AYMD(&YYMD, -7,'I8YYMD');
-SET &TODAY_5 = EDIT(&TODAY1_5, '9999/99/99');
-SET &DATE1 = (&TODAY_5 | ' 00:00:00');
-SET &DATE2 = (&YESDAY | ' 23:59:59');
-SET &REPORT_DT1 = EDIT(&DATE1, '9999999999');
-SET &REPORT_DT2 = EDIT(&DATE2, '9999999999');

I would like to change the format of &REPORT_DT1 and &REPORT_DT2 from printing as 02/14/2014 to 14/02/2014.

I used the following statement to display the range.
HEADING
"From &REPORT_DT1 to &REPORT_DT2 "

This message has been edited. Last edited by: <Kathryn Henning>,


release 7.6.4
OS: windows 7 professional
EXL2K, HTML
February 11, 2014, 03:12 PM
Waz
Please look into the CHGDAT function, it is detailed in the Function Manual with other legacy date functions.


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!

February 12, 2014, 10:14 AM
Mikey
Heres an example of how I moved my dates:

-DEFAULT &STARTDATE = 02/14/2014;

-SET &START_DATE = EDIT(&STARTDATE,'$$$999$$$$') || EDIT(&STARTDATE,'999$$$$$$$') || EDIT(&STARTDATE,'$$$$$$9999');

-TYPE &STARTDATE
-TYPE &START_DATE
-EXIT


8007
Windows 7, PDF, Excel
February 12, 2014, 10:17 AM
Mikey
Here it is with your example:

 
-SET &YESTERDAY = AYMD(&YYMD, -1, 'I8YYMD');
-SET &YESDAY = EDIT(&YESTERDAY, '9999/99/99');
-SET &TODAY1_5 = AYMD(&YYMD, -7,'I8YYMD');
-SET &TODAY_5 = EDIT(&TODAY1_5, '9999/99/99');
-SET &DATE1 = (&TODAY_5 | ' 00:00:00');
-SET &DATE2 = (&YESDAY | ' 23:59:59');
-SET &REPORT_DT1 = EDIT(&DATE1, '9999999999');
-SET &REPORT_DT2 = EDIT(&DATE2, '9999999999');
-SET &NEW_DATE_1 = EDIT(&REPORT_DT1,'$$$$$$$$99/') || EDIT(&REPORT_DT1,'$$$$$999$$') || EDIT(&REPORT_DT1,'9999$$$$$$');
-SET &NEW_DATE_2 = EDIT(&REPORT_DT2,'$$$$$$$$99/') || EDIT(&REPORT_DT2,'$$$$$999$$') || EDIT(&REPORT_DT2,'9999$$$$$$');

-TYPE &YESTERDAY
-TYPE &YESDAY
-TYPE &TODAY1_5
-TYPE &TODAY_5
-TYPE &DATE1
-TYPE &DATE2
-TYPE &REPORT_DT1
-TYPE &REPORT_DT2
-TYPE &NEW_DATE_1
-TYPE &NEW_DATE_2

-EXIT
 



8007
Windows 7, PDF, Excel