Load data from current and last year

[Anonymous]

Hello,

i have data from year 2014 on the database, however the data is in the format 201401, 201402 and so on.

how could it be done on the script to load data from current and last year without having to do it where date > 201601, i mean, i want it to be automatic so i don´t have to change it on new year.

Thank you

[aarkay29]

Create a variable and use it in the where statement

Let vStartDate= Date(YearStart(AddYears(today(),-1)),'YYYYMM');

Where DateField >='$(vStartDate)';

[muthukumar77]

Hi,

Can you send sample data?