Qdabra qRules

Re: Correct Syntax for pulling dynamic date range

Hilary Stoupa — Tue, 08 Jan 2013 22:13:27 GMT

I'm thinking you'll need to combine BETWEEN w/ addDays - something like:

concat("ModifySqlQuery /dsname=ByteproAGS /where=where Status.ClosedDate between '", addDays(today(), -365), "' and '", today(), "' and Loan.LoanWith is not null and Borrower.SSN='", SSN, "'")

Re: Correct Syntax for pulling dynamic date range

douglasjenn — Tue, 08 Jan 2013 20:33:43 GMT

I'm using SQL 2008. It isn't time specific.

What I'm needing in other words is, if at any given moment the query is run, if it is 356 days or less from the "closed date" value to now(), pull the result. I'm new to this language so please forgive me.

Re: Correct Syntax for pulling dynamic date range

Hilary Stoupa — Tue, 08 Jan 2013 15:47:52 GMT

You'd use a concat and some formulas for getting the correct range values - what version of SQL are you on? If 2005 or later, you can use BETWEEN otherwise you'd need ClosedDate < ... and ClosedDate > ....

Do the values in ClosedDate include time?

Correct Syntax for pulling dynamic date range

douglasjenn — Tue, 08 Jan 2013 15:35:45 GMT

I need to modify the following statement to only return rows from a SQL database where the "closed date" has been within the past 12 months (moving target since the query could be run at anytime during the year). What is the correct syntax to handle this?

concat("ModifySqlQuery /dsname=ByteproAGS /where=where Status.ClosedDate is not null and Loan.LoanWith is not null and Borrower.SSN='", SSN, "'")

Thanks.