I've run into a data-modeling stumper. I have a database table which
contains wedding anniversaries and the respective couple's name. The date
is stored as the wedding date, so calculating the anniversary is easy. The
primary usage of this is to display the anniversaries on a monthly calendar.
However, now i need to select just the anniversaries which will be coming up
in the next week. The problem is that since the dates are stored with the
original years (i.e. 11/28/1970), I can't just select the dates that are
between a specific date range, because the year will throw that all out of
whack. So how can i select based just on the month/day, also taking into
account that in the middle of the "week" the month can change to the next
month (November-December)? Any ideas?
Cheers,
David
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
