maryjane9110024 (10/9/2012)

---

Hi! I am trying to select records between July 1st 2011 and August 14, 2011. I am not returning any rows at all. I have searched and tried a few different things but nothing is working.

My SQL:

select *
from [Assessor_Forms].[dbo].[tblRental] 
where TransactionDateStamp >= convert(datetime, '07/01/2011')
and TransactionDateStamp < convert(datetime, '08/15/2011')

Please let me know what I need to do differently.
Thanks!
MJ

where TransactionDateStamp > '20110701'
and TransactionDateStamp < '20110815'

Sean Lange (10/9/2012)

---

What datatype is TransactionDateStamp? If it is datetime there is no need for the convert.

where TransactionDateStamp > '20110701'
and TransactionDateStamp < '20110815'

If you have your string as yyyymmdd it will work implicitly casting to a datetime regardless of the dateformat settings of the server.