Mike I am not sure I understand it, but wouldn't it be easier to store the creation date, then the type of event (weekly, monthly etc) then do a routine check on the DB to see if the date has passed and not pull it out.
CF has many date functions that will allow the ability to get the day of the week or even the week number etc. So for instance if the event is to be held on a Wednesday then store this and do a check for this week day number! I would need to know more about the project, but from the information provided this is what I would do. -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Monday, 31 December 2001 12:31 PM To: CF-Talk Subject: Any ideas on how to do this please? I am embarking on a sub-project to allow suitably authorised users to input events to my web site, to be displayed a month before the event happens, and automatically deleted after the event is over. I want the users to be able to put in an event as being held on a specific date, weekly, every two weeks, every month, on the third Friday of the month etc. How would I handle these options? I know about how to do the specific date one, but for say the monthly events, do you think I should take their input and process it to enter 12 event records for the year, or do that processing at the time of displaying the event? How would I process "the second Wednesday of the month" into a specific date? Since this is a pro bono site for a small hobby club, I'm not able to buy a calendar app, but is there a freeware tag that can handle this kind of thing? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks 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 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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