Hi,
I know that it,s probably been discussed many times, but I can't find it.

How can I have the proper previous day when we're the first of the month ?

I've used:
-SET &PDAY = DATEADD (&YYMD, 'DAY', -1);
-TYPE &PDAY

But it gives me 20140700 when &YYMD = 20140701, it's supposed to be 20140630...

I also tried with DATEMOV(&YYMD, 'WD-') but it stays the same date.

Thanks for your help and reminder :-)

This message has been edited. Last edited by: MartinY,

Hi,

Take a look at the AYMD function ... run this:

-*
-SET &PDAY = DATEADD (&YYMD, 'DAY', -1);
-SET &N_PDAY = AYMD (&YYMD, -1, 'I8YYMD');
-*
-TYPE YYMD ------- &YYMD
-TYPE PDAY ------- &PDAY
-TYPE N_PDAY ----- &N_PDAY

jfr99's code is much prettier but here goes my aproach anyway:

-SET &PDAY_V2 = &YYMD;
-SET &PDAY_V2 = DATECVT(&PDAY_V2.EVAL, 'I8YYMD', 'YYMD');
-SET &PDAY_V2 = DATEADD(&PDAY_V2,'D',-1);
-SET &PDAY_V2 = DATECVT(&PDAY_V2.EVAL, 'YYMD', 'I8YYMD');
-SET &PDAY_V2 = EDIT(&PDAY_V2,'9999/99/99');

-TYPE &PDAY_V2

Thanks, I knew that I would find an answer :-)

Here's another way:

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

DATEADD only works on Smartdates.

As &YYMD is just a number and not a date, you need to use AYMD, as works on legacy dates.