Long time lurker, first time poster.

I have an issue that I believe I may be over thinking. It seems like it should be so simple.

Here's the deal.

We have a cabinet of customer files that is packed to the brim. We want to thin it out a bit. So I wanted to utilize Crystal Reports to determine which accounts are no longer active.

So in my report I have the Company Names and the Sales Order dates. I want it to show any company that hasn't had a sale in the past 5 years and also filter out any companies that ordered before 2006 (we have companies in the database all the way back to the 90's but didn't start keeping files until 2006).

The problem I'm having is that when I use selection criteria on the date range it will only show dates between 2006-2008... but I want it to hide the company name if they have a sales order dated beyond 2008.

I feel like I'm over thinking this and it isn't as hard as I'm making it out to be. But I've been trying to make it work for a week and googled to no end.

If this isn't clear enough I'll happily provide more information or attempt at clarifying further.

Thank you in advance for your help. :)

I should have been more specific.

The data goes into the 90's. The HARD files in the cabinet only go back to 2006.

The reason this is relevant: we have over 13,000 customers/companies listed in our database. So if I left it open ended and said I wanted to list any and all companies that did business before 2008 (but not after) I would have an enormous list.

And probably 3/4 or more of that list wouldn't be of use because they don't have hard files in the cabinet that need to be pulled out anyway. Since we didn't start keeping hard files until 2006.

Hope that makes a little more sense.

:)

Here is an example of what I'm getting..

COMPANY NAME            S.O. DATE

ABC COMPANY             1/2/2006
                            5/5/2008

ALPHA COM               2/2/2006
                             1/2/2007
                     
BETA COMP               1/1/2006
                             1/1/2007
                            1/1/2008


The problem is that ABC company made a sale in 2011.
And Beta comp made a sale in 2013.

Since those companies have made sales within the last five years I do not want them to show up. At all. I only want to see companies that made sales between 2006 and 2008. Nothing before nothing after.

I don't seem to have a problem with the years before 2006 with this configuration.

Edited by chonchos - 03 May 2013 at 5:59am

I tried it out.

MAX ({SO_DETAIL.ENTRY_DATE}) < #5/3/2008#
AND MIN ({SO_DETAIL.ENTRY_DATE}) >= #1/1/2006#

It says "The remaining text does not appear to be part of the formula".

I tried it with and without the pound signs.

I placed it in the Select Expert under SO_Detail.Entry_date as a formula.

What am I missing?

I also tried the date (2006,00,etc) but did not try CDATE.

I'll try CDATE and report back. Hopefully someone else will be able to provide an alternate solution.

Thank you for your help so far.