Problems with Date Function Displaying previous date 1

[jjones100]

I am having problems using the Date function. At times it displays the previous date. I have tried using the Now function, but I do not need the time that it includes. The Now function will display the correct date while the Date function displays the previous day. My system date appears to be correct in windows. Any ideas?

 

[RoyVidar]

Rename any control you have currently namen "Date" to something else;-)

Prefixing the functions with the library can also be done within coding

[tt]msgbox vba.date[/tt]

or use

[tt]msgbox cdate(clng(now))[/tt]

Roy-Vidar

 

[jjones100]

Perfect...thanks so much!