Survey123 Connect If date between statement calculation

[TKSHEP]

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! 

[Jim-Moore · Accepted solution]

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:

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

Hope this helps, Jim