Orchestrator - Groovy, formatting results of SQL fetch
In an Orchestrator Connector making a SQL call and returning JDE Julian dates in my row, how do I format these to MM/DD/YY using "import java.util.Date", The dates need to be formatted before putting into a JSONarray.
def rows = sql.rows("SELECT SDDCTO,SDTRDJ,SDPDDJ,SDADDJ,SDCNDJ,SDIVD,SDLITM,SDDSC1,SDUORG,SDSOQS,SDUOM,SDNXTR FROM DVDTA.F4211 WHERE SDDOCO=${OrderNum} and SDDCTO=${OrdType}");
I appear to be struggling with the syntax.