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. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Google+: https://plus.google.com/117357905892731200369 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
