1 Reply Latest reply on Apr 9, 2018 9:50 AM by Deepak Rai

    Label A date difference Calculation Today's Date

    cesar gomez

      I have a due date column. I can do a date difference calculation from Today's date. I need help on creating and output label based on the number of days left from the due date.

       

      So as an example if I have a calculation of 6 days left I want it to be labeled Due Date Near. if Its passed the Dude Date I want it to Say OVERDUE with the Color Red.  Below are labels and color codes for each.

       

       

      On TimeGreen
      Due Date NearYellow
      Late HazardOrange
      OVERDUERed