Creating relationship between 2 date tables

[Yuiitsu]

Hi All

I have a date table that looks like this:

And I have another table that has a date column like this:

I believe the reason I am unable to create relationship between this 2 column is because the time behind is different.

Please advise how can I work around this? I am only looking at the dates here the time is not necessary. And my raw data by default will include the time behind

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, remove the time stamp into another column.  Now create a relationship between the Date column of the 2 tables.

[Yuiitsu]

Can you please advise how should I split it?

[Ashish_Mathur]

By delimiter > space.

[PhilipTreacy]

Hi @Yuiitsu 

Your Date Table starts in 1992, when does it end?  You need the last date in the Date Table to be beyond any date in your data.  The last date should be the last date in the year i.e. 31-12-xx.

Regards

Phil

[Yuiitsu]

My last date is 2099, 12,31 .