Quote:
Originally Posted by sriram225 View Post
U Haven't used "and" keyword to join both conditions..use it like this..
WHERE TranDate>1/1/2008 andTranDate<1/1/2009
That won't work without # delimiter.

Quote:
Originally Posted by sriram225 View Post
And Also be Sure that TranDate is Text dataType ......
TranDate is obviously Date data-type.

Sriram, don't be hurried to post.
Take your time and include all you want to say in one post.

Last edited by SaswatPadhi; 2Jun2009 at 17:32..