Date relation returns nothing

My main data is in ‘Sheet1’. I created a new sheet called ‘Dates’, with column A just being a list of sequential dates. I then created a relation column, to ‘look up’ each date in Sheet1. However, it’s completely blank. I’m wondering if this is something to do with Glide storing the date as date/time (so nothing matches exactly)? If so can someone please tell me what maths to use to ‘strip out’ the time element so the relation will work? (or whatever other workaround I need). Thank you!

Easiest is to convert the dates to integers for the purposes of the relation.
Use the following in a math column:

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

Do that in both tables, and use those columns for your relation.

1 Like

Ya…never make relations using date columns…too many variances.

Thanks for this! For some reason I don’t understand, before I managed to do this (and about an hour after I set up the date relation column), it populated with all the related data.

However, I’m going to remember this because I’m sure I’m going to need it again… keep running into challenges with dates.

Common story :wink:

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