tag:blogger.com,1999:blog-10215713.post-1109343360939869422005-02-25T09:52:00.000-05:002005-02-25T10:36:53.840-05:00It is something that I worked on for 6 hours, and finally I found a way to get it works.<br /><br />Here is the way to get all row that has a field between two dates :<br /><br /><em><span style="font-size:85%;">String.Format("DATE >= #{0}# AND DATE REQUIS < #{1}#", CDate(txtDebut.Text).ToShortDateString(), CDate(txtFin.Text).AddDays(1).ToShortDateString())</span></em><br /><em><span style="font-size:85%;"></span></em><br />Don't forget that you should not try that with a Date that is converted in a string, it won't work.Sébastien Lachancehttp://www.blogger.com/profile/02110334757221237231noreply@blogger.com