Sql query , Date time problem.

[IamMacro]

hulp5 = "02-02-2006"
timesynced = Date.Parse(hulp5)
Dim msqlDA As New MySqlDataAdapter("select * from Work where DateCreated <' " & timesynced & " ' ", myconnection)

I cant seem to get the "timesynced "
when i do every date smaller than my Timesynced it returns all the values that have
<Datumcreated>0 001-01-01T00:00:00-08:00</datecreated>

any date Larger than my Timesynced i get the entire table , so my guess is that my Timesynced variable is not doing its job.
whats the problem the
Timesynced has been parsed to Date..


Thx.

[Motoma]

I think you have your date format backwards: 'yyy-mm-dd' is the proper way.