Date change issue

I have a date column, but I want to create a virtual column for year and month like

01/01/2020 to 2020-January

Hello @Anchor_Appadmin, try this formula for your virtual column:

CONCATENATE(TEXT([Date_column),"YYYY"),"-",TEXT([Date_column],"MMMM"))

2 Likes

For reference:

2 Likes

Or maybe even

TEXT([Date Column], “YYYY-MMMM”)

TEXT() is indeed powerful.

3 Likes