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.
Solved! Go to Solution.
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.
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.
Thank you. The expression is working. I created a virtual column to store this data.
Can I also store this as a Date (MM/YYYY) so I can asscending this by date?
Thx Robert
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.
sorry,
got it - now it works!
Thx.
Robert
@Robert
Great you had it.
I just noticed the Column type was incorrect: Date instead of Text
Hi,
Thatโs what I did:
but got an Invalid Format exception:
Thx.
Robert
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |