Skip to main content
Question

Color coding based on dates

  • March 21, 2023
  • 0 replies
  • 55 views

Hi, 

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

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

    if(AdjustYear(Today(), -2) < [last revised date],"yellow")

    You can use most of the color names or else select hex codes from here 

    https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000010&dr=1



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement