hello to all!

im working in a new type of operative system, windows ME, and im having some problems with the format im getting from a DTpicker control, since im letting it in and trying to use it as a normal date, but something is not working good at all, when im trying to get the date format from a query, like
"SELECT * FROM TBLCLIENTS WHERE CLIENT_ID > 0 AND DATE BETWEEN #12/02/2000# AND #12/03/2001# ORDER BY LASTNAMË"

what is wrong with this, is there a way that i can use an standar date format that can avoid the operative system rules and work with the format i programmed to work with?

let me know, if you can my friends!

let me know how i can attach my proyect to this email so you can see what i say, and see what is wrong in it!