>workdate = sclhist.datetime
>count for sclhist.datetime = workdate

This has something to do with milliseconds stored in the table, but when saved to a variable it is reverted to 00 milliseconds. The only way it would find a match is if the table value had 00 milliseconds. Check out thread#226705