Converting a Date

2006-05-10 Thread Paul Giesenhagen
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 ~~~

RE: Converting a Date

2006-05-10 Thread Ben Nadel
: 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? Than

Re: Converting a Date

2006-05-10 Thread Tony
i would do this: #dateFormat(myVar,'mm/dd/')# tw On 5/10/06, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > 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 > tha

RE: Converting a Date

2006-05-10 Thread Everett, Al \(NIH/NIGMS\) [C]
Quick and dirty. -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

Re: Converting a Date

2006-05-10 Thread Tony
[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, 200

Re: Converting a Date

2006-05-10 Thread Nick Tong - TalkWebSolutions.co.uk
there's a nice tag on CFLib.org for this. On 10/05/06, Tony <[EMAIL PROTECTED]> wrote: > i would do this: > > > > > > #dateFormat(myVar,'mm/dd/')# > > > tw > > On 5/10/06, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > > I have a variable that has a date in this format: 20060508 (w

Re: Converting a Date

2006-05-10 Thread Paul Giesenhagen
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" Sent: Wednesday, May 10, 2006 2:46 PM Subject

RE: Converting a Date

2006-05-10 Thread Munson, Jacob
Not to toot my own horn, but I can hold my own with regex, although I tend to stick to the Perl syntax that CF supports, no more complicated than that. Michael Dinowitz is one of the best, he teaches regex classes at CFUnited. Maybe our names were Ben in a previous life... ;) > -Original Mes

RE: Converting a Date

2006-05-10 Thread Ben Nadel
MAIL 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" <

RE: Converting a Date

2006-05-10 Thread Brian Polackoff
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" Sent: Wednesd

Re: Converting a Date

2006-05-10 Thread Paul Giesenhagen
Perfect .. thanks!! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: "Ben Nadel" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, May 10, 2006 3:01 PM Subject: RE: Converting a Date > My bad, syntax e

Re: Converting a Date

2006-05-10 Thread Tony
and im sure there are more, but for all those bens to be good at regex in such a small community :) thats wild. and everyone else, jacob is too :)P aight, back to your normal cftalk goodness. tw On 5/10/06, Munson, Jacob <[EMAIL PROTECTED]> wrote: > Not to toot my own horn, but I can hold my