Skip to main content

How to group rows by date so that groups are formed by day, without taking into account time. To get a group of October 4 with 2 rows and October 5 with 2 rows. I understand that the question is in the time display, but if you make a separate column with the formula DATETIME_FORMAT({Posting Time}, 'DD MM YY') and then group by it, then the program takes the date for text and sorts without taking into account the month, only by day.

Hello,

You can add a formula to duplicate your field "Posting Time" and remove "include time" in the formating options of the formula:

Regards,

Pascal


Hello,

You can add a formula to duplicate your field "Posting Time" and remove "include time" in the formating options of the formula:

Regards,

Pascal


Thank you very much, everything worked out


Reply