Date Account Opened Query

Aug 01, 2006 1 Replies

So, I can pull up the first invoice from every customer I have and the date on it is essentially the day the account was opened.



Is there any way for me to generate a report that will simply contain the info for the first sale for every customer? I would, of course, filter out all the info except for the date and use this to determine my account growth over the course of a couple of years.



My plan is to take this data into excel and make a chart showing monthly account gropwth over a 2 year period.



TIA



Andrew


List all invoices and sort them by customer and invoice date and export to excel and delete all invoices except the first one for each customer.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required