Assuming two different fields each hold date and time: <cfset myDateTime=DateFormat(myquery.mydatefield,"mm/dd/yyyy") & " " & TimeFormat(myquery.mytimefield,"hh:mm:ss")>
Again, assuming you want to apply formatting masks to each. If you don't, then just <cfset myDateTime=myquery.mydatefield & " " & myquery.mytimefield> That's it. I'm done for the day. Time to see whats left in the liquor cabinet. -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED] Sent: Saturday, September 13, 2003 9:23 PM To: CF-Talk Subject: Adding Time to a Date Howdy, Having a major brain fart here... If I have a date (say, 9/15/2003) and a time (say, 8:00 AM), how do you put the two together? In pseudocode, something like this: <cfset myDateTime = myDate + myTime> Thanks. -- Chris Montgomery ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
