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.