Loading

Search Records Based on Custome Date Range

Search Records Based on Custome Date Range

Yogesh Sharma

Yogesh Sharma

10y1kVisual Basic .NET

Dear all friends,

here some months as...

12 Dec

01 Jan

02 Feb

Then i want find records which is belongs to these three months..

The resulted records must be in Dec jan and Feb.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Imtiyaz Ansari10y ago
Hi Yogesh
you can used IN operator

ex.
Select * From TableName where month in ('Dec','Jan','Feb')
K P Singh Chundawat10y ago
try this
Get Month from you given Date and Pass it as where condition in your sql query. I am using here month function of SQL severe.
SELECT * FROM youtable WHERE MONTH(youcolumnName) =yourMonth --Month should be numeric.