Relation not pulling in data - help with configuration of Relation

[nirmala_shome]

I’m trying to get a relation set up between two tables. One table I have today’s date and an empty text field to pull in a daily affirmation.

All the affirmations and their corresponding dates are stored in a separate table.

I’ve tried to set up a relation but there is not data coming through - wondering if I’m setting this up correctly. Attached are shots of the tables and how I’ve set up the configuration.

I want the column Today’s Mantra to pull from my Full mantra table:

Here is the table I want it to reference with the data column named and formatted the same:

here is my configuration

[Jeff_Hager]

You have to consider the time that’s attached to that date. If the dates match, but the times don’t, then then relation will still fail because it’s not truly a match. That Now date is changing every 10 seconds because the underlying time is being update regardless of the forward facing formatting that only displays the date.

You have a handful of options.

• Convert all dates to YYYYMMDD. using math so they become numbers instead of dates.
• Create Template columns that convert your dates to static text without underlying times.
• Or use a Query instead of a Relation so you can compare where one date ‘Is Within’ the other date (Is Within ignores time).

[nirmala_shome]

Thanks I was able to use a quary to get this working