I've dealt with these date issues in the last couple of weeks. The solution
is to put quotation marks around the date you are passing to DateFormat.
This tells it to treat it as a string.
<cfset pDATEOFMAINT = #DateFormat("#DATEOFMAINT#", "dd-mmm-yy")#>
Scott
Scott Brader
USAV Group
5485 S. Westridge Dr.
PO Box 510620
New Berlin, WI 53151-0620
Phone: 262.814.2000
Fax: 262.814.2006
Amateurs practice until they get it right,
Experts practice until they can't get it wrong.
Any opinions expressed are mine and are not representative of USAV Group.
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 11:00 AM
To: [EMAIL PROTECTED]
Subject: Ascii Date to CF Date
After I have imported my Ascii file, I have a date which is displayed as
'9/9/2000'
Now, I though that if I use the format statement
<cfset pDATEOFMAINT = #DateFormat(DATEOFMAINT, "dd-mmm-yy")#>
this would put my date in the proper format.
This should be treated no different then if it was passed via a form. Now I
could parse the data out and put it in the right format, but is this the
best practice for doing this.
Thank you and I'll be busy reading up on how CF treats dates.
Jim Ray
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
