How to get data between the two dates?

[kvijayhari]

hi

i'm using the between operator to list all the transaction between the dates and it's working fine.

But i want to list all the transaction from a table including the startdate and the enddate.

What should i do??????

[r937]

i think you should post more information

[maksimovic]

if you want to INCLUDE records containing start & end dates, "where" clause should be something like this:

...where YourDateField >= 'start' and YourDateField <= 'end'

not quite sure if this is what you need, and, yes, you should have posted more details

[Dan Grossman]

BETWEEN is inclusive of both endpoints (equivalent to >= and <=). Careful comparing dates to datetimes/timestamps though... when a date is converted to a datetime, it's taken at time 00:00:00, so nothing occuring on that day would be included in the results.