Color coding based on dates

Question

Hi,&nbsp;
I'm trying to add color coding to my report for records that have a last revised date of on or before 2 years from the current day's date. Is there a formula for this?------------------------------Amy Migliore------------------------------

markshnier__you · Answer

You can make a real colorization formula on the table report.&nbsp;&nbsp;

if(AdjustYear(Today(), -2) &lt; [last revised date],"yellow")

You can use most of the color names or else select hex codes from here&nbsp;
https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&amp;qid=-1000010&amp;dr=1------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Color coding based on dates