Problem with SQL Select command

[Drew_gable]

hi all,

can someone please help me I am having problems with this SQL Select command

SQLCommand = SQLCommand & "WHERE JournalDate Between '" & FrmJournalRoll1.txtStartDate.Text & "' AND '" & FrmJournalRoll1.txtEndDate.Text & " AND PoSNumber='" & FrmJournalRoll1.txtPoS.Text & "'"

If I enter in example 12/10/2009 in both the txtstartDate (text box) and 12/10/2009 it finds everything with no errors.

BUT if I enter a wide date range say 01/09/2009 to 20/09/2009 it is finding dates from 01/01/2007 and 01/01/2009 can someone please point out where I am going wrong?

Thanks

[gibra]

Database?
Date format?

[Drew_gable]

Database is SQL Server 2005 Express
date format is DD/MM/YYYY (eg 01/11/2009)

[gibra]

Show the whole SQLCommand string value ...

[Drew_gable]

SELECT * from JournalRoll WHERE JournalDate Between '01/09/2009' AND '20/09/2009' AND PoSNumber='001'

this is what is printed in the debug window

[gibra]

Originally Posted by Drew_gable

SELECT * from JournalRoll WHERE JournalDate Between '01/09/2009' AND '20/09/2009' AND PoSNumber='001'

this is what is printed in the debug window

OK, the SQL string seem to be correct.
JournalDate is a String or Date field type?