4 Replies Latest reply on Jul 26, 2016 2:52 PM by Tom W

    Anchor Initial Date

    stephanie pensler

      Hi there

       

      Trying to measure the INITIAL "expected close date" change over time.

      For context - the "Report date" field below represents the snapshot date the report was generated from the system.

      The Opportunity ID below had an initial expected to close on 8/18/2016 but change to 12/14/2016 on 7/20/2016.

      How do I create an "Initial Expected Close Date" field.

      Something like -- return the expected close date for the first report date.

       

      Stuck MANY THANKS for any help!

      Sheet 1.png