Project a Date Field

To project a date field of type DateTime, use the EXTRACT() function on the date field in the SELECT statement.

CloseDate
2014-12-30 16:00:00

This example projects only the year from the DateTime field.

CloseDate_Year
2014