Group by week or month?

I have a table with a bunch of records each of which has a Date field. I created a function field whose formula =


and it returns a value. But the Page Builder won’t let me group on this field. Why not? What am I doing wrong?


Hey @WilliamPorter,

I’ve created a report internally about the number output and date type for Equations not grouping correctly.

However, I did find a way to work around this. To group by month, you may add the following Equation.


It will group your records by month as shown in the image below.

If you want to group a bit differently, do let me know and I’ll see what I can come up with! :smiley:

1 Like