Thanks. Removing quotes however produced: 568521023.
Not nayhting near: 11-04-2007 -----Original Message----- From: Marius Milosav [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 8:55 AM To: CF-Talk Subject: RE: date format display Try removing the quotes around get.enddate #dateformat(get.enddate,"YYYYMMDD")# Marius Milosav ScorpioSoft Corp. www.scorpiosoft.com It's not about technology, it's about people -----Original Message----- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: October 4, 2007 8:43 AM To: CF-Talk Subject: date format display Hello, I brought this up before, but I need a date (displayed for example as: 20071104) to be formatted to display as 11-04-2007. It is not a date/time field just a char field in SQL. The name of the field is "enddate". Thanks as always. Robert O. I tried: #dateformat("get.enddate","YYYYMMDD")#, but get Parameter validation error for function DATEFORMAT. The value of the parameter 1, which is currently "get.enddate", must be a class java.util.Date value. Tried formatting with CreateODBCDate, but get: {d '56852-10-23'} or DateFormat(CreateODBCDate(get.enddate), "mmmm d, yyyy"), I get : October 23, 56852 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
