Conditional formatting based on a date field

[ashill]

Newb diving into conditional formatting needs help.

I have two fields – “Date Received” & “Due By”

“Due by” is a calculation field -> Date Received + 21

I would like to use conditional formatting to change the color of the “Due By” field

Black for 21-15 days remaining

Blue for 14-8 days remaining

Orange for 7-1 days remaining

Red for 0 days remaining

I’ve been trying to come up with the correct calculation for Black only (baby steps) but I can’t figure it out.

Am I remotely close to being on the right path with this formula?

GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≥ 15 and GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≤21

Any advice?

[comment]

Black for 21-15 days remaining

"remaining" as if counting from today? I don't see Get(CurrentDate) anywhere in your formula.

[ashill]

Hi Comment, thanks for responding.

I don't want it to count from today. I want it to count from the "Date Received" field.

[comment]

IIUC, the count from "Date Received" is always 21.

[ashill]

Ugh....I'm glad it's Friday because i'm clearly burned out. Thanks for pointing that out. :doah: