Discussions

Expand all | Collapse all

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

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

    Posted 07-11-2017 21:00
    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","")


  • 2.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-11-2017 21:36
    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", "")


  • 3.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-11-2017 22:19
    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


  • 4.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-11-2017 22:50
    I like "pink", its a soft red that translates well to reports.


  • 5.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-12-2017 14:13
    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


  • 6.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-13-2017 17:48
    Very useful color selection tool - thanks Mark!


  • 7.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-13-2017 17:59
    Thx Laura :)


  • 8.  RE: I'm trying to create a report that colors a row red if a date field has a date past 9 days

    Posted 07-13-2017 19:40
    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