Date formula

[grecon]

Hi I need a formula that will do specific dates but not include customers outside that date. In other words say from 3/1/2012 -2/28/2013 and 3/1/2011 - 2/28/2012 but if the customer ordered in 3/1/2012 - 2/28/2013 they shouldn't be included in the count for 3/1/2011 - 2/28/2012

Any ideas how I would do this. Thanks

 

[NiteClerk]

I don't have the exact coding, but you should be able to use two Parameters. Call them Start and End. The customers enter the request dates there. Then in the Report/Selection Formula/Record you have something like:

{Table.field} in Date(?Start) to Date(?End)

HTH.

Bob