I trying to execute the following statement, when the exception is catched, I have displayed what the variable lcSQL evaulates to

lcSQL = "select count(meetingnumber) from meetings where iscancelled=0 and roomclosed=0 
lcSQL = lcSQL + " and isblock=0 and BeginTime beween " + lcStartDate + " and " + lcEndDate

<pre>
select count(meetingnumber) from meetings where iscancelled=0 and roomclosed=0 and isblock=0 and BeginTime beween 01/01/2006 00:00:00 and 12/31/2006 00:00:00

I'm using VB.NET

Any idea's what I'm missing.

Thanks

Kirk