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.
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!
