If your intent is to use "Weeks" as in the "Nth week of the year", just use DateAdd. Then do 3 more dateAdds for the days, mins, and hours.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Lisa Donnelly [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 12:17 PM > To: CF-Talk > Subject: CreateDateTime function?? > > > I'm new to CF and I have hit a wall. > I have 4 select lists (numeric); > Weeks > Days > Minutes > Hours > and I need the user to select a value from each of these > lists. The problem is, how to store the selected values into > one field of my database? I cannot see how CreateDateTime as > weeks is not included in the function. Thanks in advance ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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

