I need to calculate the beginning and ending dates for both current year and prior year using the -SET parameter. I need to incorporate the -SET parameters in a define based on a report date that is in year/month format and is defined as A6 character field. Thanks.

 
For example, if a user selects a beginning date of 201601 and an ending date of 201712 (a two year period), I need to define counts based on the following parameters.

-SET &BEGIN_CURRENT YEAR (should = 201701)
-SET &END_CURRENT YEAR (should = 201712)
-SET &BEGIN_PRIOR_YEAR (should = 201601)
-SET &END_PRIOR_YEAR (should = 201612) 

This message has been edited. Last edited by: Michele Brooks,

Michele

This should do the trick...


-SET &CURRENT_YEAR = EDIT(&YYMD,'9999');
-SET &PRIOR_YEAR = &CURRENT_YEAR - 1;
-SET &BEGIN_CURRENT_YEAR=&CURRENT_YEAR | '01';
-SET &END_CURRENT_YEAR=&CURRENT_YEAR | '12';
-SET &BEGIN_PRIOR_YEAR = &PRIOR_YEAR | '01';
-SET &END_PRIOR_YEAR = &PRIOR_YEAR | '12';


For example, if a user selects a beginning date of 201601 and an ending date of 201712 (a two year period), I need to define counts based on the following parameters.

-SET &BEGIN_CURRENT_YEAR = EDIT(&USER_SELECTED_ENDING_DATE,'9999') || '01'; (should = 201701)
-SET &END_CURRENT_YEAR   = &USER_SELECTED_ENDING_DATE;                      (should = 201712)
-SET &BEGIN_PRIOR_YEAR   = &USER_SELECTED_BEGIN_DATE;                       (should = 201601)
-SET &END_PRIOR_YEAR     = EDIT(&USER_SELECTED_BEGIN_DATE,'9999')  || '12'; (should = 201612) 

Chuck, I don't think this will work because I won't know what date range that the user will choose. The source files has data from 201501 to present. This is how the defines should work. I might need to do defines as opposed to -SET commands. The date in the source table is called DASH_MONTH_VALUE/A6 (year & month). The user will enter a 2 year period date range. Sorry for the confusion in my first post. Thanks.

Start Date the user may enter: 201504
End Date the user may enter: 201703

Current Beginning Year Date = -1 year from the End date the user enters (201604).

Current Ending Year Date = End Date the user enters (201703)

Prior Beginning Year Date = Start Date the user enters (201504)

Prior Ending Year Date = 1 year after the Start Date the user enters (201603)

Michele

Gotcha... I think Tom has your answer...

quote:

Originally posted by Tom Flynn:
For example, if a user selects a beginning date of 201601 and an ending date of 201712 (a two year period), I need to define counts based on the following parameters.

-SET &BEGIN_CURRENT_YEAR = EDIT(&USER_SELECTED_ENDING_DATE,'9999') || '01'; (should = 201701)
-SET &END_CURRENT_YEAR   = &USER_SELECTED_ENDING_DATE;                      (should = 201712)
-SET &BEGIN_PRIOR_YEAR   = &USER_SELECTED_BEGIN_DATE;                       (should = 201601)
-SET &END_PRIOR_YEAR     = EDIT(&USER_SELECTED_BEGIN_DATE,'9999')  || '12'; (should = 201612) 

Thanks Tom, I had to tweek your code a little, but your code got me started in the right direction. Thanks so much to both you and Chuck.