Skip to main content
Question

Row colorization base on date (current, a day before, and past due)

  • August 4, 2017
  • 0 replies
  • 47 views
Forum|alt.badge.img+6
I am trying to create the following colorization based on a date field:
1 day prior to [ETA] & [Arrival Date] is empty = yellow
[ETA] = today's date & [Arrival Date] is empty = green
[ETA] date has passed & [Arrival Date] is empty = red

Thank you!
    This topic has been closed for replies.

    I think this will work in the colorization formula:

    If([Arrival Date]=��,Case([ETA],1=ToDays([ETA]-Today()),�#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())<0,�#ff0000�),��)
    Terms & ConditionsAccessibility statement