Date problems.................

[cornishteeth]

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

 

[cornishteeth]

Figured it out. For everyone that wants to know the outcome, it had to deal with reference libraries I had selected on my terminal vice everyone elses.

http://www.mcse.ms/archive154-2004-2-429039.html

Thanks for looking,

Frank