I'm trying to create a report that colors a row red if a date field has a date past 9 days

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I'm trying to create a report that colors a row red if a date field has a date past 9 days - If ([Date Released for Inspection]> days+(9) ,"red","")
Photo of John

John

  • 40 Points

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
if more than 9 days in the future:
 If ([Date Released for Inspection]> Today()+Days(9) , "red", "")

if less than 9 days in the past:
If ([Date Released for Inspection]< Today()-Days(9) , "red", "")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
John, you will find that red is too hard to read though.

There is a great tool here out up by another great QuickBase solution provide, Laura Hillier.  https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1

so instead of where you have red, you would put in the hex code like #E55451
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I like "pink", its a soft red that translates well to reports.
Photo of John

John

  • 40 Points
Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you
(Edited)
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
Very useful color selection tool - thanks Mark!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
Thx Laura :)
Photo of John

John

  • 40 Points
Thanks... the color was not so much the answer I need. I need the formula to make that happen when the dated released for inspection is past 9 days.
Thank you