Dates

[#1]

Hi

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?

Thanks

[sunny_talwar]

May be use Floor() function to remove the time component of the date and time field?

[#3]

Hi Sunny thanks for your reply. I tried it but it doesn't work.

[sunny_talwar]

What script did you use?

[#5]

Floor(date)

[#6]

Floor(date)

[sunny_talwar]

The complete script