Survey123 Connect If date between statement calculation

TKSHEP — Tue, 06 Aug 2024 19:55:07 GMT

I am looking for help on creating an if date between Jan and March then return 1 value to autofill quarterly text value field.

Any help is greatly appreciated.

Thank you!

Re: Survey123 Connect If date between statement calculation

Jim-Moore — Wed, 07 Aug 2024 05:01:46 GMT

Hi @TKSHEP

One way to approach this would be to use the format-date() function to get the month as a number. You can then use something like if(${my_month}<=3, 'Q1', 'Q3 - Q4') to return the value you want. For example:

JimMoore_1-1723006842196.png

For more on date formatting, see the Formulas topic in the documentation.

Hope this helps, Jim

topic Survey123 Connect If date between statement calculation in ArcGIS Survey123 Questions

Survey123 Connect If date between statement calculation

Re: Survey123 Connect If date between statement calculation