How to sort it by year month?

1

I’m having a hard time to create to group by year month in a sortable way.

2

Hi Walter! One way I have solved this issue is using the date.Year(), date.Month(), and date.Day() formula to convert a date formatted column into separate columns for whichever component of the date you are looking to sort.

This would result in March becoming 3, and you can group or sort that column numerically.

Hope this helps!

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.