I need to eliminate all years from a table except the current year

[deerhunter]

/* 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;

[Zhandos_Shotan]

Hi!

Try the folowing changes:

1) Use = Year(Today());

2) Fix this:    Where [Fiscal Year])= '$(vMaxDate)' ;   

to Where [Fiscal Year]= vMaxDate;

[deerhunter]

Hmmm, did not work?
Using:
Let vMaxDate = Year(Today());
Returns:
Field vMaxDate not found
Where [Fiscal Year= vMaxDate;

[deerhunter]

/* 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 */

Here is the code:
Let vMaxDate = Year(Today());
CurrentYearsData:
Load
*
Resident AllData
Where [Fiscal Year] = $(vMaxDate)

Any ideas?