CURRENT_DATE()-14 becomes CURRENT_DATE()

rbuser

Hello,

I am using Report Builder with Pervasive SQL. "CURRENT_DATE()-n", where n is
an integer is supported by Pervasive.SQL.

Problem:
When I create a report with a search field specifying that a date should be
greater than CURRENT_DATE()-14, it only works until I save and close the
report. If I re-open the report, the search is now for a date greater than
the CURRENT_DATE().

If I enter the SQL manually, it works fine, but I can't use this method
because the report must be editable using the query wizard.

Please help. Thanks,

Imran Khan

nicocizik

Hi Imran,

I apologize for the delay, for some reason my newsreader did not initially
pick up your post.

Which connectivity and SQL version are you using? Does this behavior only
occure when loading a saved template?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com