troubleshooting Question

Dates with in a tolerance traffic light system

Avatar of Gareth_Pointon
Gareth_Pointon asked on
Microsoft SQL ServerASPMicrosoft SQL Server 2008
18 Comments1 Solution266 ViewsLast Modified:

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.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 18 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros