[Public Designs]

SELECT        SalesOrderID, SalesOrderDetailID, ProductID, LineTotal, ModifiedDate
FROM            Sales.SalesOrderDetail
WHERE        (ModifiedDate = 'July 1, 2005') OR
                         (ModifiedDate = '07/01/2005')
ORDER BY SalesOrderID, SalesOrderDetailID

This is what I have and is not bring back any values. I am again using the adventure works database.
Am I setting up the date selection wrong because I know there should be some brought back but the statement is returning nothing.

Thanks

[Cocker081288]

Could it be your date format?

It may not be working because its expecting the where clause to be '01 July 2005' as it could be currently reading it as '06 01 2005' instead.

Cocker081288, on 17 July 2011 - 01:02 PM, said:

Could it be your date format?

It may not be working because its expecting the where clause to be '01 July 2005' as it could be currently reading it as '06 01 2005' instead.

sorry I meant 07 01 2005

[Public Designs]

No. I have tried that and it brings back no results as well

[Ionut]

When working with dates in SQL, I use the following format: 'YYYYMMDD'

select * from Table where DateField = 'YYYYMMDD'

Also, you have functions to convert the date to a format that you like. Take a look at convert. Here you find the list of all functions to manipulate dates.
Finally, if the query doesn't return any value, delete all the where conditions and add one by one and see where the result set dissapears. In your case, try using < or > or other date to see if you get any values.