I am trying to set an inbox filter to get records submitted in the last 10 days. I started with just checking for records before current date using the syntax from the Survey23 website:
Datefield<CURRENT_DATE
where its mentioned that this must be used on a text field using the format yyyy-mm-dd, and will not work on a date field.
So my text field is "txt_unic_id" and it writes values as "2019-05-16"
With this inbox filter, txt_unic_id < CURRENT_DATE, I get error message: invalid query parameters
Question 1: whats wrong with my current syntax and
Question 2: how to insert the 10 days criteria once question 1 solved
Thanks
Hi Rene,
Inbox Filter by Date in Query Expression addresses how to properly format a relative date query.