AnsweredAssumed Answered

Dumb question about finding "previous date."

Question asked by DavidMoore on Apr 11, 2017
Latest reply on Apr 11, 2017 by philmodjunk

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!

Outcomes