Skip to main content
Solved

Grouped by 1 field

  • October 3, 2024
  • 2 replies
  • 29 views

Forum|alt.badge.img+4

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.

Best answer by Pascal_Gallais-

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

2 replies

Pascal_Gallais-
Forum|alt.badge.img+21
  • Inspiring
  • 213 replies
  • Answer
  • October 3, 2024

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


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 1 reply
  • October 3, 2024

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