Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
07-02-2007, 10:22 PM #1
- Join Date
- May 2005
- Thanked 0 Times in 0 Posts
Choose which rows to display depending on date
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 #2
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.