Beast Mode: Reverse Date Count
Hi All, I have a database containing project information updated on a day by day basis. A project will have an associated RAG (red, amber, green) status and the corresponding date. For example, Project X was red for 10 days, then green for 3 days, and red for 7 days up to today. I need a statement which, first, identifies…
