User defined SQL

rbuser

I wish to set up some SQL manually to select Invoice records which are older
than the current date - 30 days.

I have tried using the paramater current_date + others but so far I have
failed to identify how I reference the system date in Report Builder SQL.

Any suggestions greatfully received.

Philip L Jackson

digitalmetaphors

This is dependent on if your database provides a current datetime function.
You can enter this function call into the search criteria field in a DADE
query dataview. Check your database vendor's documentation for the proper
function name.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

Here is a download demo project which does this in code for a DADE dataview.
http://www.digital-metaphors.com/tips/DADEWithCurrentDateCriteria.zip


Cheers,

Jim Bennett
Digital Metaphors