-
Database & Date
I have 2 fields in my access database namely
date_from and date_to.
Now I am getting two dates in intervels from the user, for example;
27/02/2002 to 05/03/2002.
Now I want to check whether any one of the date between the above mentioned dates are exists between the date_from and date_to in the database. Please help me to search with Database. I am using Simple Data Control.
-
Can you not use the filter property?
DataControl.Filter = "Date_From >= " #27/02/02# & " AND Date_To <= " & #05/03/02#