Date()

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

This problem has baffled me beyond recognition. I have a
database that works fine on my terminal. I have created
queries that deal directly with date functions.

30DaysPrior: DateAdd("d",-30,[InstructorXferDate])
=Date() ****Actually on a Report

Here is the error message when I run the query that has
30DaysPrior: DateAdd("d",-30,[InstructorXferDate]) in
it.....

Function is not available in expressions in query
expression '(((DateAdd("d",-30,[InstructorXferDate]))'

When I run the report that has =Date() on it. It does not
work.
Why does it work on my terminal and not on another. Do I
need some sort of library installed. Please help.

Thanks,
Frank
 
Back
Top