If you pass in a date it's treated just as a string comparison which doesn't work well with much other than EqualTo. The current workaround for this is to turn the date into a timestamp and do the comparison on that.