Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Jan 03, 2006 04:27 PM|LINK
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
CONVERT(datetime,CONVERT(nvarchar,EntryDate, 1)+' 00:00:00 AM')
BETWEEN @StartDate AND @EndDate
but it didn't work either.