9 Replies Latest reply on Aug 22, 2016 2:47 AM by Steve Taylor

    Finding 1st Order received

    Elberti Uiterwaal-Postma

      Hi,

       

      I have the following table:

       

      I want to be able to create a Dimension Field with the Date of the 1st time that this client actually ordered something. In this case the date I would want is May-2013. The first order was 632 in May-2013.

       

      Can anyone help me figure out how to calculate this date.

       

      Thanks,

      Elberti