# Find a date from a list of dates

**URL:** <https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944>\
**Category:** Ask for Help\
**Created:** [October 31, 2022, 2:31am UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944 "2022-10-31T02:31:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Glidy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidy/32/49903_2.png) [@Glidy](https://community.glideapps.com/u/Glidy)\
**Post date:** [October 31, 2022, 2:31am UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944/1 "2022-10-31T02:31:52Z")

</div>

How do I find the date from a list of dates.

I tried to create by if then else and there seems to be no option to do this search.

 ![Capturar](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98831472e2b69176d185519bd698526f8054b5e3.png)

I needed to find the specific day, for example 11/03/2022 from this lookup list

Thanks in advance

---

<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:** [October 31, 2022, 2:50am UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944/2 "2022-10-31T02:50:49Z")

</div>

It depends. Here are two methods.

- First method. _ONLY_ use this method if the Date you are looking up has been sourced from the same list of dates. If it hasn’t, this method almost certainly _won’t_ work.  
– Create a relation that matches the date you want to find with the column that contains the list of dates.  
– Use a lookup column to fetch whatever you need through the relation

- Second method. Use this if the Date you are looking for has _not_ been sourced from the same list of dates. ie. maybe it’s user entered  
– Convert all your dates to numbers using the following math formula:

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

```

– do the same as above with the date you’re wanting to find  
– now proceed as per the steps in the first method (relation + lookup)

---

<div class="post-metadata">

**Author:** ![Glidy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidy/32/49903_2.png) [@Glidy](https://community.glideapps.com/u/Glidy)\
**Post date:** [October 31, 2022, 9:28am UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944/3 "2022-10-31T09:28:32Z")

</div>

Thanks Darren, I’ll try what you told me

---

<div class="post-metadata">

**Author:** ![Glidy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glidy/32/49903_2.png) [@Glidy](https://community.glideapps.com/u/Glidy)\
**Post date:** [October 31, 2022, 8:56pm UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944/4 "2022-10-31T20:56:27Z")

</div>

Thank you very much @Darren_Murphy , it worked here

I just couldn’t do it using the lookup, so I used the Array Contains Element

And he marked for me the dates that matched on the list

Thank you so much again, thanks and see you later

---

<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:** [November 1, 2022, 8:56pm UTC](https://community.glideapps.com/t/find-a-date-from-a-list-of-dates/52944/5 "2022-11-01T20:56:40Z")

</div>

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