6 Replies Latest reply: May 12, 2016 3:41 AM by Mohammed Mukram RSS

    Previous record value as new field

    Mohammed Mukram

      Dear,

       

      let me explain the scenario,

       

      I have 3 fields in my sample table.

       

      DOCUMENT_NO,

        DEPT_ID,

        SENT_DATE

       

      each document process through department and when ever any department send the document to other department SENT_DATE will be generated and stored.

      That SENT_DATE is Receiving date for other department.

       

      so i'm trying to create new field in the script which contain receiving date of the document department level.

      then difference between Document Receiving date  and SENT_DATE .

       

      kindly find the attached sample file and Qvd.

       

       

      Thanks,

      Mukram