Oct 03, 2024 07:29 AM
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.
Solved! Go to Solution.
Oct 03, 2024 08:43 AM
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
Oct 03, 2024 08:43 AM
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
Oct 03, 2024 10:46 AM
Thank you very much, everything worked out