How do you use date variables in DB2 SQL code?

[ToyFox]

I am trying to get a DB2 pass thru query to work. 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

 

[papadba]

Where did the term "pass thru query" originate. . .?

Why not put the dates into host variables rather than literals if you want them to be dynamic?

 

[MarcLodge]

Toyfox,
Are you talking an MS Access front end connected to a DB2 database?

I'm guessing that you are as that's the only place I've come across the term 'passthru query' before.

If so, how are you building the SQL? VBA?

Marc

 

[SkipVought]

Did you try CURRENT DATE???

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]