I have a Q.V. application where I am linking a date from my dataset to a calendar reference table.
The calendar reference table date is coming from a SQL table and is set to datetime e.g. 2013-01-01 00:00:00.000
My dataset is in Excel and I am taking it into Q.V. The date in Excel looks like a date time e.g. 26/04/2017 00:00 all dates are populated and generally the time is set to 00:00 but there are some times populated occasionally e.g. 23:59.
When I am linking, the dates with the occasional time portion filled out are not returning any data from the calendar reference table.
It is like a mismatch of data types. I've tried a few things but nothing has worked. Does anyone have any ideas?
