GaryB
11-17-2004, 09:59 AM
THIS IS FIXED. USED NOW() INSTEAD OF DATE()
Hi,
Need some help please. I have a query that has a field called month. it's data type is set as date/time. in the criteria I have an expression as follows:
between date () and date () -365
what this had been doing is controlling a report that produces data from the current date back one year. All of sudden I am getting a message
" undefined function 'date' in expression.
This has been working fine until now and I have not changed anything other than to input data. Does anyone have any idea what might be going on here?
Correction, we did upgrade the operating system to Windows XP Professional.
Thanks in advance
GaryB
Hi,
Need some help please. I have a query that has a field called month. it's data type is set as date/time. in the criteria I have an expression as follows:
between date () and date () -365
what this had been doing is controlling a report that produces data from the current date back one year. All of sudden I am getting a message
" undefined function 'date' in expression.
This has been working fine until now and I have not changed anything other than to input data. Does anyone have any idea what might be going on here?
Correction, we did upgrade the operating system to Windows XP Professional.
Thanks in advance
GaryB