Problem with query

[sarang_k]

Hi all, I want to write a query in such a way to find the list of records which are between two dates i.e., consider the two dates are StartDate and EndDate. Thanks in advance.

[Luc Pattyn]

that is elementary. read a book on databases, using the relevant Query Language. And don't post the same question in more than one forum. :|

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.
[The QA section does it automatically now, I hope we soon get it on regular forums as well]

---

[April Fans]

I think you should consider the StartDate only. SELECT listname form TABLE WHERE StartDate>='####-##-##' and StartDate<='####-##-##'

April Comm100 - Leading Live Chat Software Provider

[DX Roster]

try below query SELECT * FROM tablename WHERE startdate AND enddate IF YOU GET YOUR ANSWER THAN PLEASE RATING ME If You Get your answer then please Rating me... Thanks.. "Are You Ready" DX-ARMY

[nidhip]

hi u can try this query select * from tablename whare Datefieldname between StartDate and EndDate reply if ur problem resolved thanks