Hi, My intention is to allow a user to select 'how long' eg, months, weeks, days, hours, minutes, it took to solve a problem, this information will then be stored as one field in the database. It is the intention that searches etc can be carried out on this information for comparison. Thanks for the help so far, Lisa
-----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 04:27 To: CF-Talk Subject: RE: CreateDateTime function?? > Why add a date if you want to store an interval? I mean, if you want to > calculate a new date it is the obvious route, but the request was to > store it. Lisa: Can you confirm on your question? > is, how to store the selected values into one field of my database? Am not sure what your purpose is behind all this. ***Logically.. you would just give a drop down of dates(MM-DD-YYYY) HH:MM*** If i understand the question correctly.. User comes in and selects something to happen(e.g Email me cheap flights after this period) 2 weeks 3 days 5 hours 10 minutes... Yes the question is how do you store weeks & days & hours and minutes... My understanding is a future dateTime has to be created and the database field would be a DateTime field.. in that case...? <cfscript> //create a default current date with form data... myDate=CreateDateTime(year(now()),month(now),day(now()),form.hrs,form.mins,s econd(now)); //adding weeks here myDate=DateAdd("ww",form.ww,myDate()); //adding days here myDate=DateAdd("d",form.dd,myDate()); </cfscript> myDate would be the future date created from the form.. to be inserted into the database in one DateTime FIELD. Joe > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 6:58 PM > To: CF-Talk > Subject: Re: CreateDateTime function?? > > > Joe Eugene wrote: > > All you need is create a default date and use function > DateAdd("",defaultDate) > > and create whatever..date you want. Check previous post for code. > > Why add a date if you want to store an interval? I mean, if you want to > calculate a new date it is the obvious route, but the request was to > store it. Isn't creating a new date and converting that new date back to > an interval when you need to extract the interval just a whole lot of > extra hassle? > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
