YEAR
YEAR(date)
The year of a date as a number, such as the year a task finishes in, for grouping or comparing by year. The date is read in the schedule's UTC wall clock, the same day the grid shows.
Arguments
| Argument | What to give it |
|---|---|
| date | A date, like [Finish date]. Blank gives blank. |
Examples
Formula=YEAR([Finish date])
The year the task finishes in.
Formula=YEAR([Finish date]) > YEAR(DATADATE())
TRUE for tasks that finish in a later year than the data date.
Formula on WBS rows=YEAR([Finish date])
On a WBS row: the year the last task under the node finishes.