>Cetin,
>
>I got it. This is what I did:
>
>

>xStartTime = "04//25/04 07:00"
>xEndTime   = "04/25/04 17:00"
>
>
>mySQL =  "SELECT * from meetings WHERE StartTime BETWEEN "+;
> "ctot('" + xStartTime + "') and ctot('" + xEndTime + "')"
>rs=oConnection.Execute(mySQL)
>? rs.GetString()
>oConnection.Close
>release oConnection			
>

>
>Neil
>Thanx ever so much once again

Neil,
I'm stumped :( ^2004/04/25 07:00 style is the format independant reliable one. Anyway I'd also try this then :

xStartTime = "{^2004/04/25 07:00}"
xEndTime   = "{^2004/04/25 17:00}"

mySQL =  "SELECT * from meetings WHERE StartTime BETWEEN "+;
 xStartTime + " and " + xEndTime

rs=oConnection.Execute(mySQL)
? rs.GetString()
oConnection.Close
release oConnection			

PS: BTW Provider was VFPOLEDB, right ?
Cetin