Hi Marlon,

I'm glad you found a workaround.

I think that SQL stores the time as a fractional portion of the number. Try taking the INT() of the date and see if that results in a different value.
_________________________
Andrew Bates