Skip to main content
Question

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

  • July 12, 2017
  • 0 replies
  • 50 views
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","")
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • July 12, 2017
      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", "")
      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
      Terms & ConditionsAccessibility statement