Focal Point
[SOLVED] DATEADD error

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

October 01, 2019, 11:58 AM
BGronli
[SOLVED] DATEADD error
The code below has been working fine until this morning. It determined that &POSTDT = '2019-10-00' and I do not understand that at all. Is there some other way I should be using to take the current days date and subtract one day?
  
-SET &CURDT = &YYMD;
-SET &PREVDT = DATEADD(&CURDT, 'D', -1);
-SET &POSTDT = EDIT(&PREVDT, '9999-99-99');


Thanks,

This message has been edited. Last edited by: FP Mod Chuck,


7.7, z/OS & Win7, excel & pdf
8.2 testing
October 01, 2019, 12:07 PM
Tom Flynn
If it's NOT a Smart Date, will "always" error; also, don't need &CURDT:

-SET &PREVDT = DATECVT((DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D',-1))'YYMD', 'I8YYMD');


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
October 01, 2019, 02:50 PM
Doug
Are you guys really on 7.7x?
October 01, 2019, 03:37 PM
BGronli
Yup, although we are working towards 8.2.3 at the moment.


7.7, z/OS & Win7, excel & pdf
8.2 testing
October 01, 2019, 03:53 PM
BGronli
Thanks Tom. I did have to tweak it a bit as it threw an unbalanced parentheses error.
-SET &PREVDT = DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D',-1), 'YYMD', 'I8YYMD');  



7.7, z/OS & Win7, excel & pdf
8.2 testing
October 01, 2019, 04:00 PM
Tom Flynn
Cool Beans! Me and My Parens - should be a song!
Best Wishes with the upgrade...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe