How do I handle inspections done in the same month?

neomapper — Fri, 10 Jun 2022 19:24:17 GMT

How do I return a (Yes / No) answer to Results when New_Inspection_Date is in the same month as Last_Inspection_Date?

Re: How do I handle inspections done in the same month?

jcarlson — Fri, 10 Jun 2022 20:30:35 GMT

Do you mean same calendar month, or within a month of each other?

If the former, you could try:

if(format-date(${Last_Inspected_Date},'%y%m')=format-date(${New_Inspected_Date},'%y%m'), 'Yes', 'No')

Formatting each date as %y%m would reduce them down to the year and month, so two inspections in June 2022 will return a 'Yes', but June 2021 and June 2022 will not.

topic How do I handle inspections done in the same month? in ArcGIS Survey123 Questions

How do I handle inspections done in the same month?

Re: How do I handle inspections done in the same month?