I would make a full date, then use date format to get the result I wanted in this case, either that or use string functions like left to get what you want.
Tim -----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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
