Newest Date

[kristinaloupe]

I have a table that stores events and event dates. I need to have Crystal pick the newest event date for duplicate events.

Example: I have "Case Opened" on 2/1/2004 and "Case Opened" (again) on 12/31/2004 -- How do I force Crystal to find only the newest date?

 

[Turkbear]

Hi,
If possible, create a view in the database that selects the records with the Max date.
For example, something like ( generic, since you did not provide database info)

Create view Event_Report as select * from eventtable e where "Case Opened" = ( select max("Case Opened") from eventtable b where e.event = b.event)

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kristinaloupe]

Thank you for such a quick reply....

I do not have access to change the database itself, unfortunately, any other suggestions?

 

[kristinaloupe]

I think maybe I was asking in the wrong way so I submitted a second thread on this subject.. thanks.