Based on Paul's suggestion, I did this: SELECT TOP 1 datepart(year, pub_date) as begin_year, datepart(month, pub_date) as begin_month, datepart(day, pub_date) as begin_day FROM vcs_story_archive ORDER BY pub_date ASC
SELECT TOP 1 datepart(year, pub_date) as end_year, datepart(month, pub_date) as end_month, datepart(day, pub_date) as end_day FROM vcs_story_archive ORDER BY pub_date DESC Works for me. H. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
