How do I extract just the year in a report column?

If you want to extract just the year, month, or day from a date column, create a formula column with the following formulas respectively:

Formula: Year([Data Column Name]); Month([Data Column Name]); Day([Data Column Name])

Data Type: Date

Display Format: (leave blank)

For example, if you were to extract the year, month, and day from the Decision Date column, each formula column will appear as below:


Was this article helpful?