Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
Load * from xyz where (Year(Date) >= Year(Today()) and Year(Date) <= Addyears(Today(),5));
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