Arcade symbology based on date and field fills. Can't get to work.

SRanseen

I am making a parking violation reporting map for code enforment.  The need to see what points are open, closed, have had contact or are overdue.   I am using Arcade for symbology based on date fields.  I can get some but not all the symbology to work.  I have limited coding experience and have already spent over 4 hours on this.  I have attached my code document with my notes on what is working

Symbology I need to change on its own as the date changes within fields and also on calendar. 😀 are what I have working.

• 😀Open: ( Reporting date is not null)
• 😀Removed: (Clean up date is not null)
• 😀Contact Made 1: (Reporting date is not null and Contact date is not null  and does not exceed 2 days from reporting date)
• 😀Contact Made 2: ( Contact date is not null and Citation date is not null does not exceed 2 days from Contact date)
• Over Due 1: three days have passed since reporting and no other dates have been filled
• Over Due 2:  three days have passed since Contact date and no other dates have been filled
  
• Over Due 3: three days have passed since citation and no other dates have been filled
  
• 😀Over Due 4: Contact date is filled three days after report date filled
  
• 😀Over Due 5: Citation date filled three days after Contact date filled
• Towing:  if there has been no date fill over 24 hrs from citation day

code.docx

ukaszWiszniewski_3-1730445695584.png

kenbuja

It's much easier to work with your code when you use the "Insert/edit code sample" button. Click the three dots at the end of the icon bar, then select the </> icon.

I'm guessing you're showing three different versions of the same script you'd like to run, but if I'm incorrect, please let me know. What are the some of the dates you'd expect to see in your data? You can test your script in the Playground like this to see how it works with a variety of dates.

var clean_up_date = null;
var contact_date = Date(2023,10,6);
var reporting_date = Date(2023,10,4)
var citation_date = Date(2023,10,5);

When (!IsEmpty(clean_up_date), "Removed",
      !IsEmpty(reporting_date) && DateDiff(contact_date, Date (reporting_date), 'days') >=3, "Over Due- Warning three days over Reporting",
      !IsEmpty(reporting_date) && DateDiff(contact_date, Date (reporting_date), 'days') <=2, "Contact Made 1",
      DateDiff(citation_date, Date(contact_date), 'days') >=3, "Over Due- Citation three days over Warning",
      DateDiff(citation_date, Date(contact_date),'days') <=2, "Contact Made 2",
      "Open")