How do I return a (Yes / No) answer to Results when New_Inspection_Date is in the same month as Last_Inspection_Date?
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.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
