Relationship problem between date columns from 2 tables

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!

Here is a link to the csv:

https://drive.google.com/open?id=13xtd9hGe46ijpXKltOz12SnrurLx5YdH

I got it to work with the csv without any problems.. 

Both the date columns had to be converted to date format but otherwise i did nothing but import it and create the relationship, very strange indeed.

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)

When proposal date is imported as CSV, the dataformat is automatically set to text/string. As the string contains timestamps aswell it can only be converted to datetime, and not to date directly. Therefore you need to first convert it to datetime and then convert it from datetime to date in a new step!