Group Data by Month-Year and not Full Date

https://www.appsheet.com/Template/AppDef?appName=NewTestPhotoUpload-3272358

I want to group my data by month and not the full date. Please let me know a way as to how i can do that? Creating a virtual column doesnt work as the formula returns a Text For eg 1 for January, 2 for February etcโ€ฆI feel this should have been a standard and easy feature but havent found a way yet!

Using the Month or eomonth formula returns month as a number and appsheet doesnt detect numbers as a dateโ€ฆ

KIndly Help

0 18 1,742
18 REPLIES 18
Top Labels in this Space