Skip to Content
Former Member
Dec 27, 2007 at 05:56 PM

counting date transactions for last six months


Post Author: crystalrook

CA Forum: Formula

Any help is greatly appreciated. I am running Crystal XI.

I have an order field (PurchaseOders.PODatePlaced) for each item. There can be multiple orders in the same month for each item of course. I would like to COUNT each PurchaseOders.PODatePlaced based on the month it was purchased for the last six months from a date parameter.

My table looks like this"

Item PODatePlaced

1234 11/12/2007

1234 11/20/2007

1234 10/15/2007

1234 9/30/2006

1234 12/5/2007

1234 12/6/2007

I am trying to get the results to read as follows (only for the last 6 months):

Items December November October

1234 2 2 1

Thanks for your help