# Date relation returns nothing

**URL:** <https://community.glideapps.com/t/date-relation-returns-nothing/55903>\
**Category:** Ask for Help\
**Created:** [December 20, 2022, 2:16am UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903 "2022-12-20T02:16:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brolli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brolli/32/1099_2.png) [@Brolli](https://community.glideapps.com/u/Brolli)\
**Post date:** [December 20, 2022, 2:16am UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/1 "2022-12-20T02:16:40Z")

</div>

My main data is in ‘Sheet1’. I created a new sheet called ‘Dates’, with column A just being a list of sequential dates. I then created a relation column, to ‘look up’ each date in Sheet1. However, it’s completely blank. I’m wondering if this is something to do with Glide storing the date as date/time (so nothing matches exactly)? If so can someone please tell me what maths to use to ‘strip out’ the time element so the relation will work? (or whatever other workaround I need). Thank you!

---

<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:** [December 20, 2022, 2:18am UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/2 "2022-12-20T02:18:46Z")

</div>

Easiest is to convert the dates to integers for the purposes of the relation.  
Use the following in a math column:

```auto
Year(Date) * 10000
+ Month(Date) * 100
+ Day(Date)

```

Do that in both tables, and use those columns for your relation.

---

<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:** [December 20, 2022, 2:33am UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/3 "2022-12-20T02:33:50Z")

</div>

Ya…never make relations using date columns…too many variances.

---

<div class="post-metadata">

**Author:** ![Brolli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brolli/32/1099_2.png) [@Brolli](https://community.glideapps.com/u/Brolli)\
**Post date:** [December 20, 2022, 7:20pm UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/4 "2022-12-20T19:20:23Z")

</div>

Thanks for this! For some reason I don’t understand, before I managed to do this (and about an hour after I set up the date relation column), it populated with all the related data.

However, I’m going to remember this because I’m sure I’m going to need it again… keep running into challenges with dates.

---

<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:** [December 20, 2022, 7:35pm UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/5 "2022-12-20T19:35:46Z")

</div>

> [@Brolli](#):
>
> keep running into challenges with dates.

Common story 😉

---

<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:** [December 21, 2022, 7:36pm UTC](https://community.glideapps.com/t/date-relation-returns-nothing/55903/6 "2022-12-21T19:36:34Z")

</div>

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