Re: Date Function returning wrong date
I am unable to reproduce your problem using both Debug.Print Date and Msgbox Date when in the Immediate Window. (Yes, MsgBox works in the immediate window). Is it always wrong for you? And can you try Now(), perhaps with a FormatDateTime function and the General Date option to see if the time of day is also wrong?
Is there a chance that an Excel App object is in play here? Because Access and Excel use reference dates that differ by one day. So things COULD get confused depending on context.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.