Symbolizing off of a year

AlexBeak

Hello!  I'm using the online GIS platform and Field maps for sewer inspections.  I have a "Last Inspection Date Field" and i want to symbolize to show all pipes that have an inspection dates prior to 2025 or Blank as Red, and all pipes with an inspection year during or after 2025 as green.  

Can i do this using already existing symbology tools?  Or do i need to write an Arcade expression to create a new field?  (if the later, i will likely have more questions on how to wirte that)

 

Thanks!

Laura

Arcade for sure! I still consider myself a newbie with it too, so it took me a minute for everything to click. My setup is a little different—I have it categorized as: No Inspection, Inspected in the Last 3 Months, Inspected in the Last 30 Days, and Inspected More Than 3 Months Ago.

// Get the most recent inspection date

var inspDate = $feature.Inspected_Date;

// If no date exists

if (IsEmpty(inspDate)) {

    return "No Inspection";

}

// Calculate difference in days between today and inspection

var daysSince = DateDiff(Now(), inspDate, 'days');

// Categorize

if (daysSince <= 0) {

    return "Inspected Today";

} else if (daysSince <= 30) {

    return "Last 30 Days";

} else if (daysSince <= 90) {

    return "Last 3 Months";

} else {

    return "More than 3 Months";

}

 

To make sure it’s using the most recent inspection, I have a related table that stores all inspections, with the inspection date auto-filled for each entry. I also have the main layer (hydrants) pull the latest inspection date from that table and overwrite the previous value. That way, the main layer only ever holds one date—the most recent one—and that’s the date Arcade uses.

 

Sometimes I go back and forth with chat gbt if I'm hung up.