0 Replies Latest reply: Feb 4, 2013 11:27 AM by Hardik Gandhi RSS

    Dates (Scripting)

    Hardik Gandhi

      Hi,

       

      I have four date fields part of the same table:

      1. A - Start Date

      2. A - Stop Date

      3. B - Start Date

      4. B - Stop Date

       

      Now while loading this table I want to convert four date fields into two by picking Max dates from ( A- Start Date and B - Start Date) = New Start Date and similarly

      max (A-Stop Date and B- Stop Date) = New Stop DAte

       

      Thanks,

      H