# Group by date not working?

**URL:** <https://community.glideapps.com/t/group-by-date-not-working/65473>\
**Category:** Ask for Help\
**Created:** [August 28, 2023, 7:47am UTC](https://community.glideapps.com/t/group-by-date-not-working/65473 "2023-08-28T07:47:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![marshru](https://avatars.discourse-cdn.com/v4/letter/m/e9bcb4/32.png) [@marshru](https://community.glideapps.com/u/marshru)\
**Post date:** [August 28, 2023, 7:47am UTC](https://community.glideapps.com/t/group-by-date-not-working/65473/1 "2023-08-28T07:47:26Z")

</div>

I have an inline list which is grouped by Date (pic below), which is not working. It’s been working fine for a long time but for some reason just stopped. It’s a date only column, not date/time. Is there a bug or has something changed since I last played with this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/999d52cb3a2def4bb69081417d43611d470959f5.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 28, 2023, 8:08am UTC](https://community.glideapps.com/t/group-by-date-not-working/65473/2 "2023-08-28T08:08:16Z")

</div>

> [@marshru](#):
>
> It’s a date only column, not date/time.

Date Only vs Date/Time are just display options. Internally, all dates are always saved with both date and time. You can see this for yourself if you click into one of the rows in the Data Editor - you’ll see that there is a time as well as a date.

As to why it’s stopped working for you, I can’t explain that. How are the dates entered? Has that changed recently? Are any of your users in different timezones?

Anyway, one way to fix it is as follows:

- Start by converting your Date to an integer in the format YYYYMMDD. Use a Math column with the following formula:

```auto
Year(Date)*10^4
+Month(Date)*10^2
+Day(Date)

```

 ![CleanShot 2023-08-28 at 16.05.49@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a851514ef3c7ed6217da8facdec1e44ef341bf86.png)

- Then convert that back to a Date using the Text to Date column.

 ![CleanShot 2023-08-28 at 16.06.06@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/ccd11fd81ada6ae7a0df49c52b0574323751f0c9.png)

- The above two steps will have the effect of setting the time on all dates to exactly the same value, so you can use the resultant column to group your list and it will work as expected.

---

<div class="post-metadata">

**Author:** ![marshru](https://avatars.discourse-cdn.com/v4/letter/m/e9bcb4/32.png) [@marshru](https://community.glideapps.com/u/marshru)\
**Post date:** [August 28, 2023, 10:20pm UTC](https://community.glideapps.com/t/group-by-date-not-working/65473/3 "2023-08-28T22:20:13Z")

</div>

> [@Darren\_Murphy](#):
>
> ```auto
> Year(Date)*10^4
> +Month(Date)*10^2
> +Day(Date)
> 
> ```

Yep - that fixed it. Thanks!  
I have been doing some calculations using this date column but haven’t done anything to this column at all. I’ll have to look back carefully at what I’ve done and try to figure out what happened. Meanwhile, I have a fix so thanks again.

---

<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:** [September 4, 2023, 10:20pm UTC](https://community.glideapps.com/t/group-by-date-not-working/65473/4 "2023-09-04T22:20:26Z")

</div>

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