Stripping dates from something in the WHERE only (not in select)

[SyntaxTerror]

We have a report where we allow the user to specify a date range and pull all of the purchase orders pulled between the specified dates.

Well, there is a problem with the report.

The code is like this:
WHERE CreatedDate BETWEEN @begindate AND @enddate

If the begin date is 2011-06-29 and the end date is 2011-06-30, it is ignoring all of the purchase orders made after 2011-06-30 00:00:00, so, 2011-06-30 0:09:52 is being filtered out.

What can I do to strip the time of the CreatedDate values so they pull only the dates?

Thanks in advance!

 

[MarkSweetland]

Try


declare @begindate smalldatetime
set @beginDate = '2011-06-09'
declare @enddate smalldatetime
set @endDate = '2011-06-10'

select *
from [TableName]
where convert(varchar, createdDate, 101) between @begindate AND @enddate


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[SkipVought]

WHERE CreatedDate >= @begindate 
  AND CreatedDate <  @enddate + 1

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SyntaxTerror]

SHIZAM! Exactly what I needed.

+10 style points to you, sir