topic Re: I need to eliminate all years from a table except the current year in App Development

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

deerhunter — Sat, 16 Nov 2024 06:58:09 GMT

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

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

Zhandos_Shotan — Fri, 28 Dec 2018 04:48:05 GMT

Hi!

Try the folowing changes:

1) Use = Year(Today());

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

to Where [Fiscal Year]= vMaxDate;

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

deerhunter — Fri, 28 Dec 2018 13:06:55 GMT

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

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

deerhunter — Fri, 28 Dec 2018 14:11:17 GMT

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