Forum Discussion
Solved
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 thi...
Hi,
In the Query Editor, remove the time stamp into another column. Now create a relationship between the Date column of the 2 tables.
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 .
