# Help needed - Date field based relation **URL:** \ **Category:** Ask for Help\ **Created:** [June 6, 2021, 1:09am UTC](https://community.glideapps.com/t/help-needed-date-field-based-relation/27695 "2021-06-06T01:09:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [June 6, 2021, 1:09am UTC](https://community.glideapps.com/t/help-needed-date-field-based-relation/27695/1 "2021-06-06T01:09:30Z")
Trying to relate a table with dates populated in google sheets with standard dates (2021-03-05) to a table with job entries, where the date is created by glide - the field is: ![Screen Shot 2021-06-06 at 03.08.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9f996b627a66a5b625215190aed26d25c2126f7.png) Can not get the relationship working. Please help. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 6, 2021, 1:23am UTC](https://community.glideapps.com/t/help-needed-date-field-based-relation/27695/2 "2021-06-06T01:23:34Z")
Try using two template columns to convert them to pure text and use them for the relation instead. Your dates might contain hours, minutes, seconds, which will make it not matched. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [June 6, 2021, 1:49am UTC](https://community.glideapps.com/t/help-needed-date-field-based-relation/27695/3 "2021-06-06T01:49:03Z")
Thanks a lot… 😀 ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/help-needed-date-field-based-relation/27695/4 "2024-01-17T16:51:53Z")