One thing to add to William's code
Check to make sure the value is a date first, or it'll throw an ugly
exception.
<cfif IsDate(#form.month#/#form.day#/#form.year#)>
Datediff('d', '#form.month#/#form.day#/#form.year#', '[compared
year]')
<cfelse>
The Form Value passed in was not a date
</cfif>
On Tue, Sep 2, 2008 at 10:11 AM, William Seiter <[EMAIL PROTECTED]> wrote:
> Datediff('d', '#form.month#/#form.day#/#form.year#', '[compared year]')
>
> Put your form field names in place of the 'form.' Values. Then put the
> date
> that you are comparing them to in the [compared year] spot.
>
> The 'd' indicates to return the difference in 'days'.
>
> ----------------------------------
> William Seiter
> ColdFusion Web Developer / Consultant
> http://william.seiter.com
>
> Free Website Trade Publication >> Website Magazine
> http://www.websitemagazine.com/referrals/?id=51344&f=text2
> Don't forget to answer the survey questions, it's a 10 second task ,
> a very small request for access to this incredible resource.
>
>
> ::-----Original Message-----
> ::From: Laurie Smith [mailto:[EMAIL PROTECTED]
> ::Sent: Tuesday, September 02, 2008 10:01 AM
> ::To: CF-Talk
> ::Subject: Please Help..Confused
> ::
> ::I have 3 drop-down boxes for:
> ::Years
> ::Months
> ::Days
> ::
> ::I need to combine the values for all 3 and convert to days so I can use
> ::the total number of days with DateDiff...Any suggestions would be greatly
> ::appreciated. Thanks
> ::
> ::
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311914
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
