Have an odd situation where subtracting one day from 2021120...

[Brad Gronli]

Have an odd situation where subtracting one day from 20211201 ends up with an invalid date.

-SET &PREVDT = DATEADD(20211201, D, -1);

-SET &TEMP2 = 20211200;

Any ideas as to why DATEADD subtracting one day from the current date, when the current date was 20211201 would come up with a date of 20211200

[David Beagan]

This Focal Point post explains this issue. The date needs to be converted to an internal date format to work with DATEADD, then converted back to store in the variable. I find it simpler to use the AYMD function:

-SET &Yesterday = AYMD(&YYMD, -1, 'I8YYMD');

-TYPE Yesterday = &Yesterday

[Charles Morris 2]

If I recall correctly, DATEADD doesnt always work correctly with Dialogue Mgr, even if you change the date to internal format

[Sarah Buccellato]

Hi Brad, were David and Charless posts helpful