Query help

[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.

[Not Active]

This is an extremely simple query that is well documented. Have you even attempted to look?

---

I know the language. I've read a book. - _Madmatt

[Andy_L_J]

Look at the

BETWEEN

keyword. As Mark said, this is very basic T-SQL. What have you researched?

I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife

[Md Marufuzzaman]

Just one more think that i would like to add is the datatype/format of your datetime variables, you may need to convert.

Thanks Md. Marufuzzaman

---

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.