All you need is create a default date and use function DateAdd("",defaultDate)
and create whatever..date you want. Check previous post for code.Joe On Tue, 17 Dec 2002 23:51:57 +0100 Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Lisa Donnelly 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? > > In an interval field, although you need to > convert weeks to days and > vice-versa on the fly (in standard SQL at > least, a databases might > provide this extra functionality). > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
