Select date period with Vb.net

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

Check your structure. I created a structure like this:

CREATE TABLE dbo.FileName

(

tipcon INT

,data DATETIME

,field1 VARCHAR(25)

)

And your query ran just fine. No syntax errors. Are you sure you ahve a column called Field1?

SELECT COUNT(*)

FROM FILENAME

WHERE SUBSTRING(FIELD1, 19, 4) > 2005

AND TIPCON = '1'

AND DATA BETWEEN '2008-03-01' AND '2008-03-31'

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

The BETWEEN is fine.

What error message are you getting?

Alberto.Omini SSC Eights! Points: 957 More actions · Answer 3

now is ok.....

i forget to put ' on the sql string !!!!

thank you very much !!!!!!!