Skip to Content
0
Former Member
Jan 10, 2008 at 03:54 PM

First, last record

25 Views

Post Author: MartinC

CA Forum: Formula

Hello!

I'm trying to display the first and last record of a datetime field. I'm using the Maximum and Minimum fonctions. I am able to display the first and last record but the associated fields are wrong. Here's what I mean...

The fields in the report are the following...

MRN AssesmentDate Score1 Score2 Score3

10 Dec 20th, 2007 2 3 3

11 Dec 1st, 2007 1 1 2

12 Dec 15th, 2007 3 3 3

What I want to appear in the report are the following fields...

10 Dec 20th, 2007 2 3 3

11 Dec 1st, 2007 1 1 2

but I get

10 Dec 20th, 2007 2 3 3

11 Dec 1st, 2007 2 3 3

As you can see, the score fields for the Minimun display the Maximum fields.

Thanks in advance!