Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 29, 2021 09:35 AM
Hi -
I’m running into a problem when I try to group a list of events. The dates are from Dec. 21 up to Dec. 22 and I’ve one column witha formula that extracts the month from the date column.
I can sort my table by the date field and it’s all fine, but when I then group by month, the order gets messed up. How can I create a grid view that is sorted by month and shows the month in the right order? And in addition with a two times December (21,22) entry??
Thanks for any help!
Nov 30, 2021 12:53 PM
Assuming your formula results in “December” and not “12”, you could adjust your formula to do something like:
DATETIME_FORMAT({Date A}, "YYYY - MM - MMMM")
to result in “2021 - 12 - December” so you can group by each month in the proper order.
Sep 19, 2023 08:59 AM
I'm seeing something similar:
DATETIME_FORMAT({Date & time}, 'D MMM YYYY')This gives us friendly dates like "19 Sep 2023".
I'd expect the groups in this screenshot to be in this order: