jonahadkins/When_DateDiff.md

## When_DateDiff.md

      
    Raw
  

              When_DateDiff.md
            
          
    Esri Arcade Labeling Expression
When today's date is 12/24/36 months from attribute date, label the date with green/yellow/red.
when (
(DateDiff(Today(), $feature.date, 'months') <= 12),
'<CLR green = "255">' + TEXT($feature.date, 'D MMM YYYY') +'</CLR>',
(DateDiff(Today(), $feature.date, 'months') <= 24) ,
'<CLR yellow = "255">' + TEXT($feature.date, 'D MMM YYYY') +'</CLR>',
(DateDiff(Today(), $feature.date, 'months') >= 36) ,
'<CLR red = "255">' + TEXT($feature.date, 'D MMM YYYY') +'</CLR>',
'NO')