Hi all, I could use a little help with this one as I can't seem to find a solution for this anywhere, and I have definitely been wasting too much of my time on something so small! Anyways, I am wondering if there are any known issues with the SpreadsheetFormatColumns function in regards to formatting datetime fields from sql? I have searched and searched, and tried every variation I could think of with the following code, but cannot get it to format the dates. I would definitely appreciate any feedback on this one, or if anyone knows of any issues with this. Here is one of my code versions: <cfset sObj=SpreadsheetNew()> <cfset SpreadsheetAddRow(sObj, "Client,Leave Owner,Leave Number,Request Date,Leave Reason,Elig Confirmed Date,Packet Mailed Date")> <cfset SpreadsheetAddRows(sObj, drilldowns)><cfset SpreadsheetFormatColumns(sObj, {dataformat="mm/dd/yyyy"}, "4,6-7")><cfset SpreadsheetFormatRow(sObj, {bold=TRUE, alignment="center"}, 1)>
<cfspreadsheet action="write" name="sObj" filename="filename#dateformat(now(), 'mmddyyyy')#.xls" overwrite="true"> I could very easily write this differently, or convert the fields in sql, but since I started this to try out some of the CFSpreadsheet stuff, I wanted to see if there was a solution while still using it this way. Th ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm