Date format of VB select data from VFP

Hi,
I am Using VB 6 to develop a program and using Visual FoxPro 6.0 as my database… I am facing a problem… when i select data by using sql (e.g. select * from table1 where date between sdate and edate) ( the date format that i am using is DMY) when i select those data in VFP’s command window, the correct answer is loaded, but when i select data through my program in VB6 the result is not true…. for example … i want to select data from (DMY) 01/01/2001 to 01/03/2001 …. the data from 01/01/2001 until 03/01/2001…. This give a a very big problem on select reports in my program… is anyone can help me about this??? Thank You Very Much