Date function

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I use the date function, Date(), to perform checks to see
if the current record's date is the same as today. I've
never had any trouble with the function.

Now, where I had used the Date() function, it has been
replaced by Date - no (). I get all kinds of errors. The
Now() function still appears to work. Any ideas about what
this might be???

Thanks in advance,

Jason
 
Jason said:
I use the date function, Date(), to perform checks to see
if the current record's date is the same as today. I've
never had any trouble with the function.

Now, where I had used the Date() function, it has been
replaced by Date - no (). I get all kinds of errors. The
Now() function still appears to work. Any ideas about what
this might be???

Thanks in advance,

Jason
Click to expand...

In code, it's usual for the closing parentheses of the Date() function
to be dropped. However, the fact that you're getting errors suggests
that something has gone wrong. I can think of two things.

1. You may have created a variable, control, or field named "Date", and
Access may be interpreting your use of "Date" as a reference to that
object.

2. You may have a broken reference that is interfering with the VBA
library. In the VB Editor environment, click Tools -> References... and
look for any reference marked "MISSING".
 
Back
Top