DATADATE
DATADATE()
The schedule's data date: the date progress is reported up to and the date CPM schedules remaining work from. It stays put until the schedule is statused again, unlike TODAY, which moves on every day.
Examples
Formula=[Start date] < DATADATE()
TRUE for tasks whose start is before the data date.
Formula=[Finish date] < DATADATE() AND [Status] <> "Complete"
As a guardrail: tasks that should have finished by the data date but aren't complete.
Formula=WORKDAYS(DATADATE(), [Finish date])
The working time left from the data date to the task's finish, on the task's calendar.
Measure (on the project)=CALDAYS(DATADATE(), [Finish date])
As a measure: calendar days from the data date to the end of the project.