# Relation based on date columns

**URL:** <https://community.glideapps.com/t/relation-based-on-date-columns/8409>\
**Category:** Ask for Help\
**Created:** [May 3, 2020, 9:33pm UTC](https://community.glideapps.com/t/relation-based-on-date-columns/8409 "2020-05-03T21:33:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Petr\_Shemyagin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petr_shemyagin/32/59902_2.png) [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)\
**Post date:** [May 3, 2020, 9:33pm UTC](https://community.glideapps.com/t/relation-based-on-date-columns/8409/1 "2020-05-03T21:33:33Z")

</div>

Hello to everyone!

I have a problem trying to make relation between two Date columns at the different spreadsheet tabs. When I try to relate two other columns, which are texts, from the same spreadsheet tabs, everything works well.

Both date columns are formatted in the same way using glide data formatting tool and spreadsheets formatting.

I will be very grateful for any ideas on the reasons of the problem!

---

<div class="post-metadata">

**Author:** ![Petr\_Shemyagin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petr_shemyagin/32/59902_2.png) [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)\
**Post date:** [May 3, 2020, 10:01pm UTC](https://community.glideapps.com/t/relation-based-on-date-columns/8409/2 "2020-05-03T22:01:32Z")

</div>

I have understood that the problem is in the time component. One of the colums is based on special value - current date/time. And the other one is just date choice. That is why they are not matched using the Relationship column.

However, I don’t know how to decide this problem based on internal glide data instruments. Spreasheet functions are not okey for me because I need to do real-time calculations based on the columns.

Are there any ideas on how to take only date from date/time special value using internal data instruments?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 4, 2020, 2:43am UTC](https://community.glideapps.com/t/relation-based-on-date-columns/8409/3 "2020-05-04T02:43:19Z")

</div>

Only way I’ve gotten special value \> timestamp to work as you’re describing is to use a spreadsheet formula (`=text()` to be specific).

---

<div class="post-metadata">

**Author:** ![Petr\_Shemyagin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/petr_shemyagin/32/59902_2.png) [@Petr\_Shemyagin](https://community.glideapps.com/u/Petr_Shemyagin)\
**Post date:** [May 4, 2020, 6:18am UTC](https://community.glideapps.com/t/relation-based-on-date-columns/8409/4 "2020-05-04T06:18:44Z")

</div>

Thank you, I have forgotten about this formula! It has helped