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?
A simple function can make it easily.
Hi @dunkindonut7777 - You can also use a datetime function, if the Date field is the Date data type: DateTimeYear([Date])