I'm trying to create a report that colors a row red if a date field has a date past 9 days
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","")
Forum Discussion
- 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- I like "pink", its a soft red that translates well to reports.
- 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 - Very useful color selection tool - thanks Mark!
