Hello all,
I need to create a query to find the last time a Project status was Active. Project Status can go backwards (i.e. Active->Cancel->Active or Active -> Pending Close -> Closed -> Active) in this scenario. So even if it is Active now, need to find the creation date for the last time it was Active.
Any ideas on how to start this query, I believe the 3 tables needed to create query are:
pa_projects_all ppa, pa_tasks pt, pa_project_statuses pps.