|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 11th, 2005, 09:13 PM
|
|||
|
|||
|
date field as a critieria- help
HOw do I write correctly a query where I want to say give me everything where Created is before 1/6/2004 and InvoiceReceived are not after 1/6/2004.
So some of these results can be created before 1/6/2004 but we are still using them and invoicing is coming through, but I want to find what was created before that date and Invoicing is not coming through any more, therefore we are not using their services. Thanks to whoever helps me.
|
|
#2
May 12th, 2005, 07:07 AM
|
||||
|
||||
|
Hi,
Do you want both dates to be before 1/6/2004? try Code:
select * from table where Created < '2004-06-01' AND InvoiceReceived < '2004-06-01' or must the InvoiceReceived be after 1/6/2004? try Code:
select * from table where Created < '2004-06-01' AND InvoiceReceived > '2004-06-01' hope this helps
__________________
Look! Its a ShemZilla    
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > date field as a critieria- help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
