# Relation between two date fields **URL:** https://community.glideapps.com/t/relation-between-two-date-fields/66444 **Category:** Ask for Help **Created:** [September 22, 2023, 4:31pm UTC](https://community.glideapps.com/t/relation-between-two-date-fields/66444 "2023-09-22T16:31:14Z") **Posts on this page:** 1 **Showing post:** 2
### 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: [September 22, 2023, 5:21pm UTC](https://community.glideapps.com/t/relation-between-two-date-fields/66444/2 "2023-09-22T17:21:42Z")
It won’t work if the underlying times are different…even by a few milliseconds. The underlying values have to match exactly, regardless of any visual formatting you may have on the date column. Something along the lines of creating a math column to create a stable date value will work out much better when using it for relations. > [@How to sum values based on date (daily ,weekly, monthly)](https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313/2): > > 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: 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/relation-between-two-date-fields/66444)._