SQL Query

Select 

* FROM mylib.mycalendar WHERE MyDate between 20040401 and 20040430