Get all the values in between FromDate and ToDate

Hi, I have a table with fields fromDateTime, toDateTime, expense, and id. It looks like Table1 fromDateTime toDateTime expense Id 11.11.12 29.12.12 120 1234 16.11.12 19.12.12 839 1234 23.11.12 29.11.12 783 1234 25.12.12 30.12.12 8129 234 and now I have the parameters for the report fromDateTime and toDateTime. fromDateTime = 15.11.12 and toDateTime = 30.11.12 In my method, I wrote like while select Table1 where Table1.Id == Id && Table1.fromDateTime >= fromDate && Table1.toDateTime