B
Brian
I have a query in a database that uses the Date() function
to get today's date. I have run this query in the past
with no problem. Recently we have gotten new computers
and now I get an error that the function isn't available.
Is there something that has not been loaded? I am a
little confused because whe I go into the build part of
the query, it shows that Date() is one of the functions I
can use. I can use a workaround by using the DateSerial
(), Year(), Month(), Day() and Now() functions, but there
are other functions, such as Trim() that I do not have an
easy fix for. Any help is greatly appreciated!!
to get today's date. I have run this query in the past
with no problem. Recently we have gotten new computers
and now I get an error that the function isn't available.
Is there something that has not been loaded? I am a
little confused because whe I go into the build part of
the query, it shows that Date() is one of the functions I
can use. I can use a workaround by using the DateSerial
(), Year(), Month(), Day() and Now() functions, but there
are other functions, such as Trim() that I do not have an
easy fix for. Any help is greatly appreciated!!