# Creating relation from date picker to dates in a google sheet

**URL:** <https://community.glideapps.com/t/creating-relation-from-date-picker-to-dates-in-a-google-sheet/69679>\
**Category:** Ask for Help\
**Created:** [January 17, 2024, 11:21pm UTC](https://community.glideapps.com/t/creating-relation-from-date-picker-to-dates-in-a-google-sheet/69679 "2024-01-17T23:21:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JJ-in-Jersey](https://avatars.discourse-cdn.com/v4/letter/j/e495f1/32.png) [@JJ-in-Jersey](https://community.glideapps.com/u/JJ-in-Jersey)\
**Post date:** [January 17, 2024, 11:21pm UTC](https://community.glideapps.com/t/creating-relation-from-date-picker-to-dates-in-a-google-sheet/69679/1 "2024-01-17T23:21:06Z")

</div>

Hi all. QQ: I have a google sheet that has a date column, from 1/1/2024 thru 12/31/2024, formatted as such. I have a layout with a form container that has a date picker. When I submit, the selected date shows up in the target table. But for the life of me, I can’t seem to create a relation where the selected date matches the google sheet date.

All help appreciate.

---

<div class="post-metadata">

**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:** [January 17, 2024, 11:25pm UTC](https://community.glideapps.com/t/creating-relation-from-date-picker-to-dates-in-a-google-sheet/69679/2 "2024-01-17T23:25:28Z")

</div>

The formatted date still has an underlying time so the values do not match. I recommend using a math column in both tables to convert the dates into a number that can be used for a relation.

```auto
Year(Date) * 10^4
+ Month(Date) * 10^2
+ Day(Date)

```