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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
