I need to convert a parameter to pull the previous 2nd month. current month is 09 14, I need to pull 07 14/ I used below convert, but somthing not right:

&MTH --072014
I want &MTH1 is 062014

-SET &MTH1 = DATECVT(DATEADD(DATECVT(&MTH,'I6YYMM','YYMM'),'M', -1), 'YYMM','I6YYMM');

This message has been edited. Last edited by: <Kathryn Henning>,

-SET &THISYEAR=EDIT(&YYMD, '9999$$$$');
-SET &THISMONTH=EDIT(&YYMD, '$$$$99$$');
-SET &LASTMONTH=IF &THISMONTH EQ 01 THEN 12 ELSE (&THISMONTH - 2);
-SET &LASTMONTHA = IF &LASTMONTH LT 10 THEN '0' || EDIT(&LASTMONTH) ELSE EDIT(&LASTMONTH);
-SET &YEAR=IF &THISMONTH EQ 01 THEN (&THISYEAR - 1) ELSE &THISYEAR;
-SET &THISMONTHDAY=EDIT(&THISMONTH) || EDIT(&YEAR);
-SET &LASTMONTHDAY=EDIT(&LASTMONTHA) || EDIT(&YEAR);
-TYPE &THISMONTHDAY
-TYPE &LASTMONTHDAY
-EXIT

-SET &MTH1 = '072014' ;

-* You were very close ... DATEADD takes a full smart like MDYY or YYMD Like so



-SET &MTH1 = DATECVT( DATEADD( DATECVT ( &MTH, 'I6MYY','MDYY') , 'M' , -1 ), 'MDYY' , 'I6MYY') ;


-* you can however just add or subtract against a non 'Day' Based date like so :


-SET &MTH1 = DATECVT( DATECVT ( &MTH, 'I6MYY','MYY') -1 , 'MYY' ,'I6MYY') ;

the code worked. it came out 62014. how can I make it look like 062014?

Output an alpha date:

-SET &MTH1 = DATECVT( DATECVT ( &MTH, 'I6MYY','MYY') -2 , 'MYY' ,'A6MYY') ;

In the future, please be more consistent in your question. In your original post, you state "previous 2nd month. current month is 09 14, I need to pull 07 14", then you state "&MTH --072014, I want &MTH1 is 062014", then you show code "-SET &MTH1 = DATECVT(DATEADD(DATECVT(&MTH,'I6YYMM','YYMM'),'M', -1), 'YYMM','I6YYMM');" - first you want to subtract two months, then 1 month. You show dates as Month/Year, but your code is Year/Month...

IT worked very well. Thank you all for your help!

FYI,

There is also a legacy function called AYM that you could have used.

AYM(indate, months, output_format)

indate: I4, I4YM, I6 or I6YYM

months: Integer

output_format: I4YM or I6YYM