At this point...I've just looked at this entire report too long, But I just want &BACK to print 07/05/2005. No matter what I do...I can't seem to get this to happen.


-SET &THISDATE = &YYMD ;
-SET &TD30 = AYMD (&THISDATE, -30, 'I8YYMD');
-SET &BACK = DATECVT(&TD30,'I8YYMD','A8MDYY' );

-TYPE &THISDATE &TD30 &BACK

20050804 20050705 07052005

I know this can't be as hard as I'm making it...can someone help?

The quickest answer:

-SET &THISDATE = &YYMD ;
-SET &TD30 = AYMD (&THISDATE, -30, 'I8YYMD');
-SET &BACK1 = DATECVT(&TD30,'I8YYMD','A8MDYY' );
-SET &BACK = EDIT(&BACK1,'99/99/9999');

-TYPE &THISDATE &TD30 &BACK

or:

-SET &THISDATE = &YYMD ;
-SET &TD30 = AYMD (&THISDATE, -30, 'I8YYMD');
-SET &BACK = EDIT(DATECVT(&TD30,'I8YYMD','A8MDYY' ),'99/99/9999');

-TYPE &THISDATE &TD30 &BACK

Thank-you so much...I don't know why my brain just could not get there yesterday.