Users can vote in a contest each week from 5 pm Thursday until 5 pm next Thursday, when the next week begins. How do I find 5 pm Thursday just past?
Here is what I have but it is not working: #dateformat(DateAdd("h",17,(now() -DayOfWeek( now() ) -3)),'YYYY-MM-DD HH:MM:SS')# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4