Hi, I think you are right, and I forget that my date isn't the end of the fiscal date! Could you tell me how I can modify the code base on draycut's? I am not familiar with SAS and afraid that I enter the wrong code Is it right? if FDATE ge mdy(5,30,year(FDATE - 60)) then FiscalYear=year(FDATE - 60);
else FiscalYear=year(FDATE - 60); Many thanks!!
... View more