Ob, dateFormat() will only format the date. You need to use timeFormat() to format the time. Like this:
<CFset vDate = CreateDateTime(vStartYear,StartMonth,StartDay,00,00,00) /> <CFset vStart = DateFormat(vDate, "yyyy-mm-dd ") & timeFormat(vDate, "HH:mm:ss") /> <CFset vDate = CreateDateTime(vEndYear,EndMonth,EndDay,23,59,59) /> <CFset vEnd = DateFormat(vDate, "yyyy-mm-dd ") & timeFormat(vDate, "HH:mm:ss") /> Note the extra space after 'dd' in the date format provides the space between the date and time. You could put that there or at the beginning of the timeFormat string, or if you don't want it in the string for whatever reason, make it DateFormat(vDate, "yyyy-mm-dd") & " " & timeFormat(vDate, "HH:mm:ss") Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4522 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
