Yep, this will do it :
<cfset now = now()> <cfset intMonth = Month(now)> <cfset txtMonth = MonthAsString(intMonth)> <cfoutput>#txtMonth#</cfoutput> Rich's SQL is prob best... Your original mail said it was held in the DB as dd/mm/yyyy, but you also said it was a string? Neil -----Original Message----- From: Martin Gill [mailto:[EMAIL PROTECTED]] Sent: 12 August 2002 10:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Bloody dates ...PIE !!!!!!!!!! Try the cold fusion function #MonthAsString(month_number)# Hope this helps Martin -----Original Message----- From: Paul Fennell [mailto:[EMAIL PROTECTED]] Sent: 18 August 2002 10:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Bloody dates ...PIE !!!!!!!!!! Right I Have a known date in the Db inthe format ... dd/mm/yyyy I want.. ( gawd why.. ) to get the date from a month as a string Ie august.... but .. how the hell do you convert month as a string to an 1-12 format with out the silly use of a massive switch statement or udf ... rar .. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
