Maybe try using CreateDate first?
<cfset delDate = CreateDate(form.year,form.month,form.day)>
----- Original Message -----
From: "Will Swain" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 8:05 AM
Subject: RE: data nonsense
> Micheal,
>
> That generates an error. There is an extra " at the end, and you cannot
have
> commas inside the CreateODBCDate statement, as it only takes one argument.
>
> This doesn't generate an error:
>
> <cfset deldate = #CreateODBCDate(#form.year#/#form.month#/#form.day#)#>
>
> However, when this date is entered: 25th May 2001, it creates this: {d
> '1899-12-30'}!!
>
> I have also tried this:
>
> <cfset deldate = #CreateODBCDate(#form.day#/#form.month#/#form.year#)#>
>
> Which makes 25th May 2001 as {d '1900-01-04'}, also wrong as you can see.
>
> Any other ideas?
>
> Cheers
>
> Will
>
> -----Original Message-----
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 24 April 2001 13:34
> To: CF-Talk
> Subject: Re: data nonsense
>
>
> Throw away this:
> <cfset formatdate = #DateFormat(intdate, "dd/mm/yy")#>
>
> And Use this:
> <cfset deldate = #CreateODBCDate(#form.year#,#form.month#,#form.day#)">
>
> instead of this:
> <cfset deldate = #CreateODBCDate(formatdate)#>
>
> Thanks,
>
> Michael Lugassy
> Interactive Music Ltd.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
