In fact, because with true/false, 0 is false, any other number is true you could just have
WHERE scandate-int(scandate)
you don't need to include <>0 as another comparison - although I accept it probably makes the code easier to understand
to illustrate in the immediate window (now is today and includes time, date is just today)
?now()-int(now())<>0
True
?cbool(now()-int(now()))
True
?date()-int(date())<>0
False
?cbool(date()-int(date()))
False