Group Report by Month and show current month first.
Hi there Community,
I'm trying to pull a report that shows my due dates for all my projects. I want to group the due dates by month. I created a formula that pulls the month name from the due date. If I have a project that's due 6/15/22 and another one due 6/27/22, the formula will pull 06 JUNE for both of them. I then want to sort my report so that anything due this month will show up first, anything due next month will show up second etc...
Any ideas?? When I sort with the above mentioned formula, it puts January first, not the current month.
Help Article Resources
Check out the Formula Handbook template!