crude, but it works consistently: <cfset year = Left("20060523",4)> <cfset month = Mid("20060523",5,2)> <cfset day = Right("20060523",2)>
<cfoutput>#CreateDate(year,month,day)#</cfoutput> On 8/8/07, Scott Stewart <[EMAIL PROTECTED]> wrote: > > Convert 20060523 > > > > Into 5/23/2006 > > > > I'm at a loss. > > > > Thanks in advance > > > > sas > > > > -- > > Scott Stewart > > ColdFusion Developer > > > > SSTWebworks > > 4405 Oakshyre Way > > Raleigh, NC. 27616 > > (703) 220-2835 > > > > http://www.sstwebworks.com > > <http://www.linkedin.com/in/sstwebworks> > http://www.linkedin.com/in/sstwebworks > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4