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 , October 01, 2019 04:17 PM 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');
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.
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'); October 01, 2019, 04:00 PM
Tom Flynn Cool Beans! Me and My Parens - should be a song!
Best Wishes with the upgrade...