Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SpreadsheetFormatColumn - formatting a date

Posted on 2010-09-20
2
Medium Priority
?
1,310 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:WebStalkers
2 Comments
 
LVL 6

Accepted Solution

by:
reiters earned 1000 total points
ID: 33720782
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
 
LVL 52

Assisted Solution

by:_agx_
_agx_ earned 1000 total points
ID: 33721836
>> {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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question