Hi Guys,
I would like to build a statistic chart in one of my (numerous) apps.
I Would like to know if it is possible in Glide to extract a month out of a date (i.e 12/4/2020 into “December”)
In Google sheet I used =UPPER(TEXT(cell,“MMMM”). however it requires for me to log into the source sheet and update the formula manually.
Is there another way to make my life easier?
Merci beaucoup mes chéris
1 Like
Yes this is possible. Add a new math column.
In the configuration, have something like. Month(m)
Then in replacement, have “m” replace by the date.
I hope this works for you.
4 Likes
Hi @SantiagoPerez,
Many thanks the trick. I need one extra step. I applied an IF>THAN>ELSE Column to convert the number into Actual Month.
God bless you
4 Likes
Heads up, It also works with years Years(y) !!!whoop whoop
2 Likes