Simple Date Wrapping Query

[Sparks78]

Hi,

I am trying to get the minimum date, where a condition is equal an identity number.

I know how to do this SQL, but I'm getting slightly lost in Crystal.

Minimum (<date/Time>, <Case ID>)
where Condition = 175

I hope this is makes sense.


TJ

 

[lbass]

Create a formula {@min175}:

if {table.ID} = 175 then {table.date}

Then right click on this formula and insert a minimum at the group level. Or if you wanted to display the minimum in the detail record, then use:

if {table.ID} = 175 then minimum({table.date},{table.ID})

...assuming you have a group on ID.

-LB