This one should be easy...... *should* being the operative word..... I have a query on an access database where its pulling a date..... when I CFOUTPUT that date, I get the big nasty date format:
'2002-01-25 08:53:36' Is there a way when the data is queried to set that field = to my DateFormat setting? i.e. <cfquery datasource="copycenter" name="goober"> select dateread AS (#dateformat(dateread, "mmm-dd-yyyy")#) </cfquery> Or is there an eaiser way to do this? I'm trying to reference this date in a CFGRAPH (and i cant format it there), so I need to format that date before it gets there, because it looks horrid.... thanks all!!!!! ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
