Latest Contributions by BobWheeler

I am trying to categorize data using arcade and dates.  It worked on a previous project but not working on the new dataset.  If the date is older than today - call it red.  If within 1 year - call it yellow and if over 1 year from now call it green.  I only seem to get one response of Red, but the data has values that should give me all three categories. var year = DateDiff(Now(), $feature["Next_Audit_Date"],'years'); return When(year <= 1, 'Yellow', year > 1, 'Green', 'Red'); ... View more

I have inspection dates to symbolize my locations.  I was using the expression below and it works fine, but now I need to add another variable. IIf(DateDiff(now(), $feature.dateauditperformed, 'years') < 1, "Inspected","2/3 Year")   Now I want those locations inspected within the last year = Current, >1 and <=2 years = Second Year, and everything else = Third year.   This is what I've been trying to work with.  All I seem to get is "other".   var year = DateDiff(Now(), $feature.dateauditperformed,'years'); if (year <= 1) return 'Current'; else if (year > 1 && year <= 2) return 'Second Year'; else return 'Third Year'; end ... View more