View Full Version : Choose which rows to display depending on date

07-02-2007, 10:22 PM
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?

07-02-2007, 10:28 PM
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.