Finding Earliest Date

building reports crystal reports
1

I used the formula

If {OPEN_TIME} in AllDatesToYesterday

Then
{OPEN_TIME}

that returned the earliest date for that field in the DB. BUT when I added another parameter, it doesn’t work:

If OPEN_TIME} in AllDatesToYesterday and
{OPENSTATUS} <> “closed”
Then
{OPEN_TIME}

Any ideas how I could get this? Thanks in advance.

Gingerly (BOB member since 2011-03-24)

2

If the structure of your report will permit a group on the date field, create a group, and pull the field up from the Details section into the Group Header section. That will display the first value, i.e., the earliest date.

Then use Select Expert for your other limitations.

Chamsin :us: (BOB member since 2008-06-05)