Filter in DataBase

[nicktekippe]

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.

[MatthiasSeil · Accepted 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

[nicktekippe]

@MatthiasSeil I attempted this but received an error for the Formula tool.

[MichaelSu]

HI @nicktekippe ,

This post may be helpful.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Filter-date-as-number-In-database/td-p...

Thanks,

Mike

[nicktekippe · Accepted solution]