How can I check if something is Overdue?
- amani imtiyas
Owned by amani imtiyas
Many elements in CAMMS Solutions have an End Date and you can often check if the item is Overdue by comparing its End Date with Today's date as well as checking its current Status e.g. In Progress, Completed etc.
So in this instance, you would create a new Calculated field using the GETDATE() function to get today’s date and compare it with the End Date and check to make sure the Status is different to ‘Completed’ as illustrated below.
IF [CammsInsightsDemo].[dbo].[Project_ProjectDetails_STND].[End Date] < GETDATE() AND [CammsInsightsDemo].[dbo].[Project_ProjectDetails_STND].[Status] <> 'Completed' THEN 'overdue' ELSE 'ok' END
