Still using Foxfire 6.06.
I have a customer who wants to compare one date field to a date ten days after another date field. I am trying to use the "build expression" option in the filters and creating the expression using the SQL dateadd function.
the filter looks like
Tickets.start is less than (build expression)
And the expression is:
dateadd(dd,10,ref_date).
The function by itself should return the date ten days after the referral date. However, when I try to run the report, I get the error:
Program ODBC_GENFILTLine 6,553Variable 'dateadd.prg' is not found
I'd really rather not create a data item for this - next time she may want to compare a different time frame to a different date. On a whim I tried putting quotes around the expression, but they pass through to the SQL, converting the function to a text string.
Is there a workaround or a tweak to make the build expression feature work with SQL expressions?