<div>
<div class="content wysiwyg-content">
Unfortunatly the documentation on cfspreadsheet is very limited on the formatting side.<br />
I only see how you can format a monetary column but I dont see how to format a date column. &nbsp;The recordset I am returning is a date/time field so I should be able to do this if this feature is allowed.<br />
<br />
What im trying to get is:<br />
<br />

<pre><code id="code-10-26486636-1">&lt;cfset SpreadsheetFormatColumn(sObj, {dataformat=&quot;MM/DD/YYYY&quot;}, myDateField)&gt;</code></pre>
<br />
Any ideas or how to set this formating? &nbsp;Or even better a good resource for the different formatting features that are allowed on these spreadsheet functions?<br />
<br />
thanks
</div>
</div>


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:

(CODE)

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

SpreadsheetFormatColumn - formatting a date

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.