I'm trying to do a traffic light type report: Red, Amber and Green
I have a date that I need to monitor what reports have so many days left.
So If I take the testDate field and add
Testdat - +8 days this is Green
Testdat(+9) - Testdat+16 days this is Amber
Testdat(+17) > this is Red
The people have 20 days to do a report and this is to show them then COUNT(*) for each colour.
Oh and its based on the current date.
I keep going around in circles but I know I have done it years ago but cannot remember how.