I have striped this code to the parts needed to demonstrate my problem.

Code:
Dim MyStartDay As Date

SELECT SchueckWkStart FROM DSWkNo where SchueckJobNo = '107 - 123456'

MyStartDay = CDate(SchueckWkStart)
This query returns a SchueckWkStart date as "2017-11-06", which is correct, but the "MyStartDay" variable will contain "2017-11-07", a day added immediately.

Can anyone explain why?