You have 4 select dropdowns and one of them Days?
You divide days/7 to get weeks. If the user selects weeks, then no of days....
you can do some like
<cfset
myDate=CreateDateTime(2002,month(now),day(now()),form.hrs,form.mins,second(now)>
<cfset myDate=DateAdd("ww",form.ww,myDate())>
<cfset myDate=DateAdd("d",form.dd,myDate())>
This should work for you.
Joe
On Tue, 17 Dec 2002 18:17:11 -0000 Lisa Donnelly
<[EMAIL PROTECTED]> wrote:
> 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
>
> Lisa
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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