Start and end times

[jongag1]

Hello,

I have a field Login (string) containing login times (hhmmss) and a field Logout (string) with logout times (hhmmss) off users.
It can happen a person logs in more than 1 time a day.
So for one day it can be:

Login
095510
095834
123404

Logout
095723
100312
165602

I would like to only display the earliest login time and to display the latest logout time, so like:

Login
095510

Logout
165602

Can somebody help me with this?

Regards,
Age

 

[jongag1]

By the way, I tried it with a formula containing minimum and maximum, but it gives met the minimum value available for all users/dates.

I have grouped the report by user, by date and I want the minimum/maximum for that particular date.

Regards,
Age

 

[dgillz]

You'll need to group by date within user, and then take the min/max for that group level.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[jongag1]

Hello dgillz,

Thanks for your quick answer.
It is currently grouped by date within users, where do you want me to take the min/max? In the created group or in the detail for that group?

 

[jongag1]

I think I know what you ment.
I dit a summary containing the min/max which is displayed in the group footer, now when hiding the details I got what I want.

Thanks again.

Age