function date not returning today's date?...

[Guest]

Thanks for any help.
I have a form in my database with some VB, and I would like to put in a
inputBox the date (minus a day or two) as the default input. I was going to
get this with:
MyDate=date
But date returns Mydate as Friday's date (as of today, Monday)! I double
clicked on the clock in the lower right, and it correctly shows today's date
(Monday).
So this seems a little strange.
Any ideas anyone?
Thanks very much.

 

[Dirk Goldgar]

Thanks for any help.
I have a form in my database with some VB, and I would like to put in
a inputBox the date (minus a day or two) as the default input. I was
going to get this with:
MyDate=date
But date returns Mydate as Friday's date (as of today, Monday)! I
double clicked on the clock in the lower right, and it correctly
shows today's date (Monday).
So this seems a little strange.
Any ideas anyone?
Thanks very much.

Do you have a field on the form (or in its recordsource), or a variable
in VBA, named "Date"? That could hide the VBA Date function, and you'd
get the value of the field/variable instead.