5 years filter in Script level(Current year to next 5 years)

[Abhi999]

in Date filed i have years from 2010 to 2040 but i want only from year(today()) to next five years.

i have tried 
year( if("Date"<=AddYears(Today(),5),"Date")) as RequiredYear.

But this logic is giving years from 2010 to 2025.i am expecting 2020 to 202

[kaushiknsolanki]

Hi,

Try this.

Load * from xyz where (Year(Date) >= Year(Today()) and Year(Date) <= Addyears(Today(),5));

[Brett_Bleess]

Did Kaushik's suggestion work for you?  If so, do not forget to close out your thread by returning to the post and on his post, use the Accept as Solution button to mark that as the solution to give him credit and let other Members know that it worked.  If you did something different, consider posting that, and then mark that as the solution to close the thread, and if you are still working on things, leave an update.

Regards,
Brett