Thanks Fred! By mistake I found out that if I just re-arrange the date to: AUG/29/01 and set it to a Date field, it automatically changes it to 8/28/2011. So that's pretty sweet!
Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Thursday, May 19, 2011 5:41 PM To: [email protected] Subject: Re: String to Date Function Since you are Oracle it is a piece of cake... Do a single Set Fields from SQL SELECT TO_CHAR(TO_DATE('$string Field$', 'DD-MON-YY'),'MM/DD/YYYY') from DUAL Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Thursday, May 19, 2011 2:26 PM To: [email protected] Subject: String to Date Function ** I have a date (i.e. 29-AUG-11) that I would like to convert to 8/29/2011. I can't find any functions in AR to do this automatically. I don't mind parsing it out and putting the DD, MMM, and YY into separate fields and then putting them all back together in one field, but is there any function that can turn "AUG" into "8" or "08"? I've been looking at all the functions and it looks like there are a lot of options to get the Weekday, Year and Month from this format 8/29/2011, but how would I get it from this format? (29-AUG-11) Lisa Kemes AR System Developer TE Information Systems Global Infrastructure and Ops +01 717 810 2408 tel +01 717 602 9460 mobile [email protected] MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 www.te.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
