Go4Expert - View Single Post

SaswatPadhi

Quote:

Originally Posted by sriram225
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
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.

SaswatPadhi ~ Б0ЯИ Τ0 С0δЭ ~
2Jun2009,17:27
	Quote: Originally Posted by sriram225 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 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..