Forum Discussion
Creating relationship between 2 date tables
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
Hi,
In the Query Editor, remove the time stamp into another column. Now create a relationship between the Date column of the 2 tables.
5 Replies
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
My last date is 2099, 12,31 .
Hi,
In the Query Editor, remove the time stamp into another column. Now create a relationship between the Date column of the 2 tables.
Can you please advise how should I split it?
By delimiter > space.
