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]

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

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

[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.

[Steve]

For reference:

help.appsheet.com

CONCATENATE()

Merged text from parts

help.appsheet.com

TEXT()

Format as text