- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 03, 2024 10:46 AM
Thank you very much, everything worked out
