Inbox filter

252
1
05-16-2019 09:00 AM
ReneAubut
Occasional Contributor

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

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

Hi Rene,

Inbox Filter by Date in Query Expression addresses how to properly format a relative date query.

0 Kudos