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






~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290160
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to