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" <cf-talk@houseoffusion.com> 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:240154 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