SQL Date between Two Date

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear,

Suppose if i have InvoiceTable consist of InvoiceNo, InvoiceStartDate, InvoiceEndDate Column then how to put the SQL between condition on InvoiceStartDate and InvoiceEndDate Below is the query of only one column.

SQL

select InvoiceNo  from InvoiceTable where
             InvoiceEndDate Date between '2011/02/25' and '2011/02/27'

Please help on this

Thanks
Basit.

Posted 17-Mar-15 22:24pm

basitsar

Updated 17-Mar-15 22:26pm

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manchanx · Answer 1 · 2015-03-17T22:32:00

I'm not quite sure what you mean by "how to put the SQL between condition on InvoiceStartDate and InvoiceEndDate" but I guess one of these will be what you want:

SQL

select InvoiceNo from InvoiceTable
where InvoiceEndDate between '2011/02/25' and '2011/02/27'
and InvoiceStartDate between '..../../..' and '..../../..';

SQL

select InvoiceNo from InvoiceTable
where '..../../..' between InvoiceStartDate and InvoiceEndDate;

Abhinav S · Answer 2 · 2015-03-17T22:31:00

Solution 1

Use an AND.
Example

SQL

select InvoiceNo  from InvoiceTable where
             (InvoiceEndDate Date between '2011/02/25' and '2011/02/27') and 
             (InvoiceStartDate Date between '2011/02/25' and '2011/02/27')

Posted 17-Mar-15 22:31pm

Abhinav S

SQL Date between Two Date

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

SQL Date between Two Date

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us