Visual Query Builder - 'datetime Criteria' -x days

[DM_88]

Hi all

Via input, I want to reduce the amount of data by adding a criteria in the visual query builder that goes 60 days back.

The column formatting = datetime: 'yyyy-mm-dd hh:MM:ss'

Thanks a lot!

Kind regards

DM_88

[Hilde_Heggen · Accepted solution]

I have the same issue, curious about how to include a relative date criteria, so following over here. 

[Christina_H · Accepted solution]

The syntax might depend on the data source you are connecting to.  I'm connecting to a SQL server, and this works:
> DateAdd(day, -60, GetDate())

[Hilde_Heggen]

That's the solution I was looking for. Thanks a lot!