# How to sum values based on date (daily ,weekly, monthly)

**URL:** <https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313>\
**Category:** Ask for Help\
**Created:** [September 19, 2023, 12:12pm UTC](https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313 "2023-09-19T12:12:01Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [September 19, 2023, 12:19pm UTC](https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313/2 "2023-09-19T12:19:59Z")

</div>

I don’t see a Date column in your table?

But, a general approach to summarise data by date is as follows:

- Use a math column to convert the date to an integer in yyyymmdd format:

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

```

- Create a multiple relation column that matches the math column with itself.
- Use a Rollup-\>Sum via the relation to sum the value/s that you’re interested in.

---

_[View the full topic](https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313)._