Creating relation from date picker to dates in a google sheet

Ask for Help
1

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.

2

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.

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