Is it possible to use Now() or Date() or CurrentDate() in the SQLQueryDesigner?

rbuser

Is it possibe to use Date functions in the Report Query Designer?
I need to create RTM report templates with Date functiones, showing Today
data, etc...

Is it possible to use CurrentDate(), Now(), etc... datetime functiones in
the Search Criteria window of the QueryDesigner?

Thanks!

nicocizik

Hi Luis,

Yes, the current version of ReportBuilder includes support for built-in
functions inside the search criteria if the DB supports them. Simply add
the function to the "Value" edit box inside a criteria field in the Query
Designer.

--
Regards,

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