topic Re: RAG status on dates in App Development

RAG status on dates

New-here1 — Mon, 11 Dec 2023 08:54:53 GMT

Hello,

I have the following code:

if([End Date]<Today(),red,
if([End Date]>7,today() and [End date]<30,today(),amber,
if[End Date]>30,today,green

The first line to show everything in red that is today's dates or less
The second line to show everything in amber that is due end in 7 days or more but less than 30 days
The third line to show everything in green that is due to end in more than 30 days

The above isn't working for me and I'm not how why. Could someone help please?

Thank you

Re: RAG status on dates

MayilVahanan — Mon, 11 Dec 2023 09:11:03 GMT

Try like below

if([End Date]<Today(), redcolor,

if([End Date]<Today() + 30 and [End Date]>Today() + 7, ambercolor,

if([End Date]>Today() + 30, greencolor)))

Re: RAG status on dates

New-here1 — Mon, 11 Dec 2023 10:10:32 GMT

This worked, thank you!