How do you search a database for records by date?

data base name= sholiday
date format=dd-MM-yyyy