Cascaded Start and End Date parameters

berk123

Hi,
I'd really appreciate if someone can advise me on how to create a list box of cascaded parameter group for start date and end date parameters which are populated from dates(timestamp datatype) in a database.

I have following query that retrieves Start Dates
select distinct entrydate from table

I pass the Start_Date parameter to following query that retrieves End Date
select distinct entrydate from table where entrydate > ? (Start_Date parameter)

Start_Date - Datetime
End_Date - Datetime
entrydate - Timestamp

Do I have to convert Start_Date parameter to string and use that has a parameter to the End Date query?

I've been struggling with this for a long time now so please help!!!

Thanks,
berk123

mwilliams

<a class='bbc_url' href='http://www.birt-exchange.com/forum/showthread.php?t=11370'>http://www.birt-exchange.com/forum/showthread.php?t=11370</a&gt;