Choose which rows to display depending on date

[Crazydog]

In my rows in my table, I have 3 separate columns storing the day, month, and year the columns were added

What's the best way to let someone choose a range of dates, and display the rows that are in that range?

[devinemke]

why are you storing your dates in 3 separate fields? just use 1 DATE field and use the BETWEEN clause to select a certain range.