In case anyone is looking at this in the future -

converting the date as date worked for me too, but it did take a while to run the query.

If anyone...