I need to query the last 30 days when my workflow runs daily. I need the syntax that will allow me to query a Julian date column that is in the integer 64 format. The column is called "current date". I tried the following syntax, but that didn't work.>= date_add('day',-30,Cast(now() as Date)).
This works, but I don't want to have to set a specific date "current_date" >= 121225. I want to always query the last 30 days when my job runs.
