6 Replies Latest reply: Feb 29, 2012 5:04 AM by Perumal Ayyappan RSS

    Data manipulating in table

      Hi

       

      i have a table of job positions contating information of each time it got vacant and then filled , having both start date and end date.

       

       

      PositionId
      Start Date
      End DateStatus
      A01.01.200330.06.20030pen
      A01.07.200315.12.2005Filled
      A16.12.200504.05.20060pen
      A05.05.200631.12.9999Filled

       

      I wnat to calculate the time period of position from vacant to being filled each time or average time of any position to be filled