not sure about access, but you could use day,year,month functions in SQL SELECT cast(Month(columnname) as char(2)) + cast(Day(columname) as char(2)) + cast(Year(columname) as char(4)) AS MyWelFormattedDAte
..soemthing like that (forgive me if the syntax is screwed up) -----Original Message----- From: Ron Davis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 6:00 AM To: CF-Talk Subject: Format Date statement? 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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
