Convert a date to a Month/year

[anonymous]

I am storing a date DD/MM/YYYY but I would like to store this in another field as MM/YYYY so I can group/count values by month. Is this possible, what would be the best way to do this. I am constantly adding new dates so it need to be dynamic. Thanks.

[Suvrutt_Gurjar]

Please try expression in the MonthYear column something like

TEXT([Your Input Date Column], “MM/YYYY”)

Assumes [Input date column] has dates in DD/MM/YYYY format.

[anonymous]

Thank you. The expression is working. I created a virtual column to store this data.

[BOTFORCE]

Can I also store this as a Date (MM/YYYY) so I can asscending this by date?
Thx Robert

[Aurelien]

Hi @Robert

If this is just for displaying purpose, you may want to use a virtual column (button “add a virtual column”)
and you can set any format you need: “yy/mmmm”, “yy mmmm”, “mm yy”, “mm/yy”…and so on.

[BOTFORCE]

Aurelien:

yy/mmmm

Hi,

That’s what I did:

but got an Invalid Format exception:

Thx.
Robert

[BOTFORCE]

sorry,

got it - now it works!
Thx.
Robert

[Aurelien]

@Robert
Great you had it.
I just noticed the Column type was incorrect: Date instead of Text