DataBricks filter in DB

[nicktekippe]

I need this filter to work in the in-DB tool or I need something that accomplishes the same thing in the code(SQL). I am pulling from databricks/edl

[phottovy · Accepted solution]

Hi @nicktekippe ,

Here is a link to all the date functions in Databricks:

https://docs.databricks.com/sql/language-manual/sql-ref-functions-builtin.html#date-timestamp-and-in...

For your example, you should be able to use this logic:

`NOTIFICATION_DATE` >= date_sub(current_date(), 730)