MonthAsString will converts X, where X is the month of the year, to a string. What you want to is to change X into a real date object. You can do this by using createDate(). Then you can use dateFormat to format the month.
Or, if you just want the three letter abreviation - aren't all of them just the first 3 letters? If so, just do left(monthAsString(x),3). ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Friday, October 18, 2002 12:30 PM > To: CF-Talk > Subject: formatting #MonthasString > > > Is there a way to format a number value retrieved for a month > (ex 10 for > the month of October) with the #monthasString# function. say to the ? > > I tried #MonthasString(month, "MM")# but it throws an error > (note:month is the field name) > > Tim > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
