Between two dates no longer works

Have just tried to show some records with my date_added field set to NOW and I get the following error: er_wrong_value: incorrect date value when I execute query.

I had a query which showed records records between two dates, Now and -60 days. This query has stopped working recently having worked for several months. The simple query above is an attempt to figure out what’s going wrong.

Original query was date.date_added between {{NOW.dateAdd(‘days’,-60}} AND {{NOW}}

The above no longer shows any records even when there are records within this day period.

Date field type is date and shows as 2022-12-12

Community Page
Last updated: