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
