Is it possible to format a valuelist like this, I keep getting errors. ValueList(day(getmonth.auctiondate)) I want to turn output like this 2003-07-12 00:00:00.0, 2003-07-12 00:00:00.0,3 - 2003-07-19 00:00:00.0 to 12,12,19 so that I can use a conditional like below <cfif ValueList(day(getmonth.auctiondate)) contains Variables.CurrentDay > Where variables.CurrentDay is a single number like 12 that is being incremented in a loop. I'm using access 2002, and MX. Jeremy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
