I have about 100,000 posted invoices in our system. I would like to find out how many we created in the month of March regardless of the year. I know I need to filter on the "Posting Date" but I don't know how to filter only on the "MM" portion of the date "MM/DD/YY". Would love some insight. Thanks.
Date
Votes
2 comments
-
Harry Lewis Hi David -
Something like this should work:
=NL("Count","Cust. Ledger entry",,"=TEXT(NF(,""Posting Date""),""mm"")","03")
-
David C. Kjeldsen Works perfectly. Thank you!
Please sign in to leave a comment.