Date change issue

[Anchor_Appadmin]

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

01/01/2020 to 2020-January

[Rafael_ANEIC-PY (Rafael Almeida)]

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

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

[Steve (Steve Coile)]

For reference:

CONCATENATE()

TEXT()

[Suvrutt_Gurjar]

@Rafael_ANEIC-PY

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

Or maybe even

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

TEXT() is indeed powerful.