12 Replies Latest reply on Jan 19, 2012 9:50 AM by BruceRobertson

    Date transpose problem using the XML(Parser) script to pass data from one database to another...

    Marc_Hussey

      Hi all,

       

      I have a problem where I'm running a script to pass a date from one database to another...

       

      Script in database 1,

      Perform Script['"Script 2" from file: "database2"; Parameter: NewXMLNode("job_numer";Jobs::Job_ID)

      & NewXMLNode ( "start_date" ; Jobs::s_JobStart )

      & NewXMLNode ( "end_date" ; Jobs::s_JobEnd )

       

      Script in database 2

      Set Variable [$job; Value:XMLParser(Get(ScriptParameter);"job_number"]

      Set Variable [$start_date; Value:XMLParser(Get(ScriptParameter);"start_date"]

      Set Variable [$end_date; Value:XMLParser(Get(ScriptParameter);"end_date"]

      Go to Layout["1"]

      New Record/Request

      Set Field[Jobs::JobNo'; $job]

      Set Field[Jobs::JobStart'; $start_date]

      Set Field[Jobs::JobNo'; $end_date]

       

      The problem is the date trasposes, in database 1 it reads 01/09/2011 in database 2 it reads 09/01/2011.

       

      Would appreciate any help on this one??

       

      Thanks