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"
