Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
/* The following does nothing, returns nothing - Table [CurrentYearsData] never gets created*/
/* AllData has 20 years of data */
/* AllData [Fiscal Year] format is YYYY - IE: 2018 */
Let vMaxDate = Year(Now());
CurrentYearsData:
Load
*
Resident AllData
Where [Fiscal Year])= '$(vMaxDate)' ;
drop table AllData;
Hi!
Try the folowing changes:
1) Use = Year(Today());
2) Fix this: Where [Fiscal Year])= '$(vMaxDate)' ;
to Where [Fiscal Year]= vMaxDate;