I need a formula to filter a date in DB. I am pulling the data from SAP HANA. The dates being formatted is in YYYY-MM-DD format. I need to filter the dates to be from today to two years ago from today. Please let me know if there is any more information I can provide.
Solved! Go to Solution.
When entirely staying In-DB here, you'd need some SQL know how in order to achieve this:
I'd do the following:
1. Use the In-DB formula to create a new column with the date two years ago from today:
2. Filter the new date column with your existing date column with the In-DB filter (larger than 2 years ago and smaller than today or equal):
If that solves your task, please mark this as a accepted solution as it helps Alteryx to keep the statistics about open and solved topics, thanks!
Kind regards
Matthias