# Relation with dates not working **URL:** \ **Category:** Ask for Help\ **Created:** [August 28, 2025, 7:27pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080 "2025-08-28T19:27:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Gustavo\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gustavo_d/32/87772_2.png) [@Gustavo\_D](https://community.glideapps.com/u/Gustavo_D)\ **Post date:** [August 28, 2025, 7:27pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/1 "2025-08-28T19:27:23Z")
I’m trying to make a relation between 2 tables using dates, but it’s not working. I’ve tried converting dates into integers but still nothing comes up. Trying to bring the computed Total Balance column from the Bank Balances tables ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/458a4ae94341a6a671cef04d086ddda45646340f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b1ac39cdce65c636bb1279cd5c94687287d26d78.png) Any hints? Thanks in advance, G ---
**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:** [August 28, 2025, 7:37pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/2 "2025-08-28T19:37:59Z")
Can you show how you converted to integers? Also show how the relation is configured. ---
**Author:** ![Gustavo\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gustavo_d/32/87772_2.png) [@Gustavo\_D](https://community.glideapps.com/u/Gustavo_D)\ **Post date:** [August 28, 2025, 9:06pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/3 "2025-08-28T21:06:02Z")
Thank you Jeff for your attention. Formula for the integers ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfb04762f64dc6efac9fb9f6bc5d1ec142103f15.png) And this is how the relation is configured ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a668f4d2c857d69a11afe72f3b413a3df454fd4.png) Best Regards, G ---
**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:** [August 28, 2025, 9:32pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/4 "2025-08-28T21:32:26Z")
Take a closer look at this. Date and Balance are not going to match each other ![1000005760](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1afa8adb338582a6c5333814336b0fbd10d3a069.png) ---
**Author:** ![Gustavo\_D](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gustavo_d/32/87772_2.png) [@Gustavo\_D](https://community.glideapps.com/u/Gustavo_D)\ **Post date:** [August 29, 2025, 2:24pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/5 "2025-08-29T14:24:24Z")
Ok, Can you explain me little bit more whats wrong and what should i change. I am kind of new with this. Again, thank you for your help and time. ---
**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:** [August 29, 2025, 2:28pm UTC](https://community.glideapps.com/t/relation-with-dates-not-working/84080/6 "2025-08-29T14:28:45Z")
A date does not match a balance. 20250131 \<\> 46 million. Your relation is comparing two very different values. If you want the relation to work you need to change it so your Date in Table A matches the Date column in Table B. Balance has nothing to do with finding a match by date. Date\_IN should be looking for a matching Bank Balances \> Date\_IN > **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)** > > Create relationships and link rows together.