Forum Discussion
Relationship problem between date columns from 2 tables
And furthermore, it has to be done in the query editor. Does not work if you attempt to do it from the normal modelling pane!
How did you manage to set the "proposal date" column to type "date"?
As I said I get an error and was not able to continue.
What I do is clicking the proposal date in the right side pane, then in the top menu change to "Date" in the data type dropdown. However then i got that error (see screenshot in previous post)
And furthermore, it has to be done in the query editor. Does not work if you attempt to do it from the normal modelling pane!
Problem solved! Also with direct query.
The problem indeed was that I didn't to the conversion to date type with the query editor.
So even if in the model it "showed" like Date, actually the dates itself were still date/time.
As a result it couldnt match the date/times of my sql table with the dates of the calendarauto because the date/times in sql contain hours and seconds (like 23:04:05) while the calendar dates have all of them 00:00:00.
Below proof of success:
I do think it is confusing that you can change type in the model while it's actually having only superficial effect.
Thanks a lot guys for helping me out on this, especially tex628 for your patience!