In the db, when doing the select statement you could use DAY(yourColumnName) and create a routine that only selects the second tuesday.
In Cf you can use day(var) or dayOfWeek(var) Taco Fleur ----- Original Message ----- From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 5:32 AM Subject: The 2nd Tuesday of every month... > I've got a site where a club meeting date is posted. It's always the 2nd > tuesday or every month. Currently, I'm using a database holding all the > tuesdays, and doing a comparison to todays date to look up the date of the > proper Tuesday to display. > > Gotta be an easier way without the database.... > > Suggestions? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
