Survey 123 Connect: Calc Monthly Inspection

[KathleenPowers]

I am trying to set up a form to perform monthly inspections. Inspections need to be completed within the calendar month, some inspectors using this form will inspect the 1st of the month, some will inspect near the end of the month. We are collecting the Inspection data, we want to calc the Next Inspection Date to equal the 1st day of the next month, regardless on which day the previous inspection was collected - examples:

Last_Inspected_on = Oct 01, 2024, Next_Inspection due = Nov 1, 2024  

Last_Inspected_on = Oct 30, 2024, Next_Inspection due = Nov 1, 2024

To query the Inbox I can ask for Next_Inspection records equal or less then the Current_Date

How do I calc a random date to result in the 1st of the next month?

[DuncanC · Accepted solution]

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Use format-date() to pull out the month and year separately.  Hit the month with int() and add 1 to it.  Then put together a date string with the new date you want and use date() to make it a date type.