How to code DB2 Pass Thru with date variables

[ToyFox]

I am trying to get a pass thru query to work. Eventually I intend to pass two dates to a function and build a pass thru that utilizes the dates. However, how do I substitute
the date values for the hard coded values in the following SQL.... thanks ... the following code works until I start playing with the date values!!!.


SELECT OPEN_DT, ACCOUNT_NO, BRANCH_NO FROM TB
WHERE OPEN_DT >= '11/1/2009' AND OPEN_DT <= '11/30/2009' GROUP BY OPEN_DT, ACCOUNT_NO, BRANCH_NO HAVING BRANCH_NO IN ('102','105', '021') ORDER BY OPEN_DT;

 

[SkipVought]

Hi,

SELECT OPEN_DT, ACCOUNT_NO, BRANCH_NO 
FROM TB
WHERE OPEN_DT >= DATE('11/1/2009')
  AND OPEN_DT <= DATE('11/30/2009') 
GROUP BY OPEN_DT, ACCOUNT_NO, BRANCH_NO              
HAVING BRANCH_NO IN ('102','105', '021') 
ORDER BY OPEN_DT;

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ToyFox]

Thanks for the response...but I probably wasn't too clear.
I want to use variables like todate and fromdate instead of the hard coded date values 11/1/2009 and 11/30/2009.

 

[dhookom]

I would use a little DAO code to change the SQL property of the saved pass-through query.

   Dim strSQL as String
   strSQL = "SELECT OPEN_DT, ACCOUNT_NO, BRANCH_NO FROM TB ..."
   Currentdb.QueryDefs("qsptMyPT").SQL = strSQL

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

WHERE OPEN_DT >= CURRENT DATE
  AND OPEN_DT <= CURRENT DATE + 20 DAYS

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}