Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter Customer List for last full month 2

Status
Not open for further replies.

gogopoppy

Instructor
Mar 6, 2005
114
CA
Hi there,

I need to filter my {CustName} field to certain customers - lets call them "acme1", "acme2" however I need to narrow it for the last full Month.

I can filter using a between however I don't want to have to keep changing the formula.

Any help would be greatly appreciated

Thanks

Suzanne
 
If you are looking for customers that were added in the last full month, and you are basing the selection on transaction dates, you should use the Minimum transaction date by Customer and use LB's logic in the Group Selection formula.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.
 
Thanks lbass and Ido,

the lastfullmonth function is what I need


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top