# Grouping display question with Date/Time formats

**URL:** <https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504>\
**Category:** Ask for Help\
**Created:** [May 1, 2022, 4:20pm UTC](https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504 "2022-05-01T16:20:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 1, 2022, 4:20pm UTC](https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504/1 "2022-05-01T16:20:20Z")

</div>

I am trying to display using ‘group by’ based on Due Date.

Some Due Date items are Date/Time (meeting) and others are just Date (task/reminder).

However, when I display them within an agenda using Group they show up as separates groups.

I am using the builtin data/time to create the meeting time but others are just the date picker.

Is their an option/feature/best practice for ‘mixing’ date/time formats within a group?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 1, 2022, 4:38pm UTC](https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504/2 "2022-05-01T16:38:06Z")

</div>

The problem is that when you group by a date column, it uses the full underlying date time, regardless of which display format you chose. Due Dates with time become separate groups because they have a different time than the date only due dates (which are actually midnight).

Create a Math column, put in X, replace it with the Date column value, then format it to date only. Then create a template column, put in X, then replace it with the math column value. This will lock in the formatting, so it’s using the forward facing date, instead of the underlying date timestamp. Finally group my that template column value.

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 1, 2022, 5:42pm UTC](https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504/3 "2022-05-01T17:42:22Z")

</div>

Thanks - worked like a charm!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 2, 2022, 5:43pm UTC](https://community.glideapps.com/t/grouping-display-question-with-date-time-formats/41504/4 "2022-05-02T17:43:05Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.