10 Replies Latest reply on Apr 11, 2017 7:30 AM by philmodjunk

    Dumb question about finding "previous date."

    DavidMoore

      Trying to discern buying patterns.

      Database has individual fiels for:

      DatePosted (date)

      InvoiceID (number - unique)

      CustomerID (number - unique)

      InvoiceTotal (number)

       

      An individual customerID may have hundreds of invoices, each with a DatePosted, and InvoiceID.

       

      It is easy through relationships to find date of first purchase and date of last purchase.

      What I'm having trouble wrapping my (pointy) head around is:

      "How do I find the purchase date of the invoice immediately prior to the last purchase date?"

       

      Any comments, as always, welcomed.

      Thanks!