Hi i have a BIRT problem, i need to group together data within two date ranges and reference to them using parameters. The query is below:


select
tfgld106.leac,
tfgld106.amth
from tfgld106
group by tfgld106.leac,tfgld106.amth
where tfgld106.crdt > ?
and tfgld106.crdt < ?
order by tfgld106.leac


now because tfgld106.crdt is a format of DateTime i am finding it hard to reference to it.......

Thanks for any help Ade