SpreadsheetFormatColumn - formatting a date

Unfortunatly the documentation on cfspreadsheet is very limited on the formatting side.
I only see how you can format a monetary column but I dont see how to format a date column.  The recordset I am returning is a date/time field so I should be able to do this if this feature is allowed.

What im trying to get is:

<cfset SpreadsheetFormatColumn(sObj, {dataformat="MM/DD/YYYY"}, myDateField)>

Open in new window


Any ideas or how to set this formating?  Or even better a good resource for the different formatting features that are allowed on these spreadsheet functions?

thanks
LVL 2
WebStalkersAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
reitersConnect With a Mentor Commented:
I have always used Ben Nadel's POI Utility.  It uses that same Apache utility behind the scenes but he has been improving the utility for a few years.  You may find you have better success with it.  I have never used the new tools in CF9 so I can not tell you which is better.

http://www.bennadel.com/projects/poi-utility.htm
0
 
_agx_Connect With a Mentor Commented:
>> {dataformat="MM/DD/YYYY"}

Honestly I'm not convinced it works ... I'd either format the dates as strings in your sql, or use POI as reiters suggested.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.