How to Create Inbox Query with DateTime Question?

Question

Hi,

I'm using Survey123 Connect Version 3.19.104 and the survey is used in the mobile app only.

I want to create an Inbox Query expression using a DateTime question. I tried different date-time formats in the SQL expression with no luck and I haven't found any documentation on how to this. I'm getting "Code 400 Cannot perform query.  Invalid query parameters."

What is the query syntax for this type of questions?

Regards.

Billy · Answer

Hi,

I tried those but didn't work either. But search on the developer's documentation I found the syntax: Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers

Thanks for your answers.

YukoYokozawa · Answer

Does your data show year-month-day? Check your data for the date, my data shows like this

I would try 10/1/2023, if not work, then 10/1/2023 12:00 PM. So try different ways to express your date

Billy · Answer

Hi YukoYokozawa,

Thanks for the reply. That works but what if I need something more specific like the example in the Survey123 documentation ( Prepare to edit existing survey data—ArcGIS Survey123 | Documentation)

I tried this syntax and got the 400 error. The second image shows the properties of the dateTime field and the syntax that I used.