Skip to main content
Question

Date Modified Colors

  • June 12, 2023
  • 0 replies
  • 69 views

How would i create color codes for the number of days since a record was modified?  For example, if a record was modified today, make it green.  If it was modified in the past 3 days, yellow and more than 3 days, red.



------------------------------
Mike S
------------------------------
    This topic has been closed for replies.

    • TylerFoster
    • Registered
    • June 12, 2023

    Hi Mike,

    Here is a formula that worked or me. I entered this into the color-coding formula at the bottom of a report.

    If(ToDate([Modified Date Test]) = Today(), "#008450",
    If(ToDate([Modified Date Test]) < Today() and ToDate([Modified Date Test]) >= Today() - Days(3), "#EFB700",
    If(ToDate([Modified Date Test]) < (Today() - Days(3)), "#B81D13")))

    You can substitute the [Modified Date Test] field for the [Date Modified] field, I created a new Date-Time field for testing. Here is what it looks like on a report:

    Please let me know if it gives you any trouble or if you have any questions! 



    ------------------------------
    Tyler Foster
    Associate Developer
    Synctivate Inc.
    ------------------------------
    Terms & ConditionsAccessibility statement