I apologize profusely for the wrong suggestion. I found this solution somewhere on the internet with plenty of explanations but couldn't test it because I didn't have access to my database from where I was when I found information on this problem. I also
tried with
CONVERT(datetime,CONVERT(nvarchar,EntryDate, 1)+' 00:00:00 AM')
BETWEEN @StartDate AND @EndDate
algocode
Member
40 Points
8 Posts
Re: Entries Not Getting Displayed for Date Range Selection(Week) between 26/12/2005 - 1/1/2006
Jan 03, 2006 04:27 PM|LINK
emr0d,
I apologize profusely for the wrong suggestion. I found this solution somewhere on the internet with plenty of explanations but couldn't test it because I didn't have access to my database from where I was when I found information on this problem. I also tried with
CONVERT(datetime,CONVERT(nvarchar,EntryDate, 1)+' 00:00:00 AM')
BETWEEN @StartDate AND @EndDate
but it didn't work either.
Help!