I have a page which allows the user to select a custom query and download a CSV. The relevant code is:
<cfsetting enablecfoutputonly="yes"> <CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=#session.MM_Username##LSTimeFormat(Now(),'hhmmmss')#.csv"> <CFCONTENT TYPE="application/excel"> <cfoutput>#fieldlist##chr(13)#</cfoutput> <cfoutput query="rsList"> <cfloop index="thisfield" list="#fieldlist#"> <cfset newfield=#rereplace(evaluate("#thisfield#"), "#chr(13)##chr(10)#", "#chr(10)#", "all")#>#trim(rereplace("#newfield#", ",", " ", "all"))#, </cfloop>#CHR(13)# </cfoutput> I want to be able to figure out if #thisfield# is a SQL date/time object so I can output it as mm/dd/yyyy instead of 2006-02-11 00:00:00.0 For some reason some of my users get this and excel interprets the date field as 00:00:00.0 instead of the date, unless you go in and manually change the format. Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4