misundertood me .. i have it as dd/mm/yyyy in the db .. however i have to use a 'string month' to query the Db ..
but its sorted now..:P -----Original Message----- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 12 August 2002 10:57 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Bloody dates ...PIE !!!!!!!!!! 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] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
