YEAR COLUMN

[dunkindonut7777]

Hi I would like to ask if how can I add a new column presenting the year of the data in reference to the date column.

Expected output:

Date	Year (new column)
2020-10-14	2020
2021-05-18	2021

Can you help me with this one pls?

[sparksun]

A simple function can make it easily.

[binay2448]

Find attached 2 solutions for the same you can use any one.

[ArtApa]

Hi @dunkindonut7777 - You can also use a datetime function, if the Date field is the Date data type: DateTimeYear([Date])