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 [cid:[email protected]]<http://www.te.com/> www.te.com<http://www.te.com/> [cid:[email protected]]<http://twitter.com/teconnectivity>[cid:[email protected]]<http://www.facebook.com/teconnectivity>[cid:[email protected]]<http://www.flickr.com/photos/teconnectivity/>[cid:[email protected]]<http://www.linkedin.com/groups?gid=1591657>[cid:[email protected]]<http://www.youtube.com/teconnectivity> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<inline: image001.gif>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
<<inline: image006.png>>
