YEAR COLUMN

Question

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:

DateYear (new column)2020-10-1420202021-05-182021

Can you help me with this one pls?

ArtApa · Answer

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

binay2448 · Answer

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

YEAR COLUMN.yxmd

sparksun · Answer

A simple function can make it easily.