Go through range of dates
Posted: Thu Sep 14, 2006 9:09 am
Hello,
I've got a few tables in MySQL that have ranges of dates (a starting date and an ending date) and in my calendar I want to be able to check the current date against those in the ranges to see if there are events... The only thing is that I can not seem to come up with a good way (or start a good way) to do this. Is there an easy way to see if a date is in a range of other dates?? Thanks for any help.
-thomas
I've got a few tables in MySQL that have ranges of dates (a starting date and an ending date) and in my calendar I want to be able to check the current date against those in the ranges to see if there are events... The only thing is that I can not seem to come up with a good way (or start a good way) to do this. Is there an easy way to see if a date is in a range of other dates?? Thanks for any help.
-thomas