> not quite as I was expecting. Take the current time, its > 11:55 am GMT, I want the result to be > (29 Jul 2003 11:00 - 30 Jul 2003 10:59)
Do you want it from the end of the previous hour? BTW, the reason I pointed you at DateAdd() and no further is that you should be able to work it out for yourself If you ask for people to do all of your "difficult" coding for you, then you'll never learn how to do it for yourself, and rely on others all of the time This isn't particularly hard, and once you have one solution, you should be able to expand it to work for all of them It's a lot better for you to work out how to do things from a nudge in the right direction than to have people always give you the solution ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4