> On 11/4/2011 8:59 AM, Torrent Girl wrote: > > > > Hi All. I need to give users the ability to download a CSV and TAB > file. While I found a neat little function to create a CVS file > (http://www.cflib.org/index.cfm?event=page.udfbyid&udfid=1197) I am > having a problem with dates values. > > > > Here is my date: 6/20/2009 7:15:03 PM but in the file it shows up > as this: 15:03.0 > > In Excel, highlight the column and format it to date. > Alternatively, save as a txt file and then open in Excel using the > filter. You can set each column to proper format that way so leading > zeros on number-text fields are preserved.
the problem is the file will be created on the fly by remote users who will import the data and won't have time to manipulate it by hand. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
