you could set up an array,structure, or a new DB table with 1,jan .. 12 ,dec "Willy Ray" <[EMAIL PROTECTED]> wrote: Ok, I'm an idiot. I have my users putting in text strings for months. I need Jan. 12 to be ordered ahead of Aug. 9 These are text records. Is there any way to do this? I guess I could parse out the first three characters of whatever my user entered, run it through a big cfswitch to assign numerical values to the months, add a leading zero to the day part... Is there any easier way? Willy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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

