Perfect .. thanks!! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com
----- Original Message ----- From: "Ben Nadel" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, May 10, 2006 3:01 PM Subject: RE: Converting a Date > My bad, syntax error: > > strDate = REReplace( "20060508", "([0-9]{4})([0-9]{2})([0-9]{2})", > "\1/\2/\3", "ONE" ); > > This one works (I tested :)) > > > ....................... > Ben Nadel > www.bennadel.com > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 10, 2006 3:53 PM > To: CF-Talk > Subject: Re: Converting a Date > > I get this error: > > "2006/05\/3" is an invalid date format. > > > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > ----- Original Message ----- > From: "Ben Nadel" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Wednesday, May 10, 2006 2:46 PM > Subject: RE: Converting a Date > > >> Try this >> >> strDate = REReplae( "20060508", "([0-9]{4})([0-9]{2})([0-9]{2})", >> "\1/\2\/3", "ONE" ) >> >> Converts to 2006/05/08 >> >> ....................... >> Ben Nadel >> www.bennadel.com >> >> -----Original Message----- >> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, May 10, 2006 3:40 PM >> To: CF-Talk >> Subject: Converting a Date >> >> I have a variable that has a date in this format: 20060508 (which is >> 05/08/2006) >> >> Does anyone have a quick and good way of converting 20060508 to a date >> stamp >> that "DateFormat()" can work with? >> >> Thanks >> >> Paul Giesenhagen >> QuillDesign >> 417-885-1375 >> http://www.quilldesign.com >> >> >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

