# Finding date in a Range **URL:** \ **Category:** Ask for Help\ **Created:** [June 5, 2022, 12:57pm UTC](https://community.glideapps.com/t/finding-date-in-a-range/42740 "2022-06-05T12:57:43Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [June 6, 2022, 1:43am UTC](https://community.glideapps.com/t/finding-date-in-a-range/42740/5 "2022-06-06T01:43:34Z")
Hola @MattLb This thread can help you to understand and have a right solution > [@Formatting dates to create relations](https://community.glideapps.com/t/formatting-dates-to-create-relations/41953): > > Greetings, I am trying to use dates to schedule pick up and drop off times for an event. I am having the toughest time creating relations. I am wondering if the format of the date makes any difference, meaning: When I input dates by hand into sheets and click on them to expand them, they look like this: [2022-05-14 (1)] However, when the user enters it from the date picker, it looks like this: [2022-05-14 (2)] Might that affect my ability to create a relation between them? I ultimately woul… Saludos! --- _[View the full topic](https://community.glideapps.com/t/finding-date-in-a-range/42740)._