Hi everyone,

I hope someone can help me with this problem...

I need to find the amount of the 2nd latest date updated on a list of orders.

For example:
Order#; Updated Date; Amt
1; 11/11; $1
1; 11/12; $2
1; 11/14; $3
2; 11/11; $1
2; 11/12; $2
2; 11/13; $3
2; 11/14; $4

So, I need:
1; 11/12; $2
2; 11/13; $3

Thank you in advance for any advice.

you could also group by order#, in the group header put a formula like:
shared numbervar ln := 1;
shared numbervar amt:= -1;
shared datetimevar dt:="1/1/1900";
"" //hide the 1 that would show

in the detail section:
shared numbervar ln;
shared numbervar amt;
shared datetimevar dte;

if ln = 2 then(
amt:={table.field};
dte := {table.field1}
);

ln := ln+1;
"" //hide the running line count

finally in the group footer 2 formulas:
shared numbervar amt;

and
shared datetimevar dte;

you could also add in some error checking in case there was no 2nd date...

HTH



Edited by lockwelle - 14 Nov 2013 at 4:47am

Thank you very much lockwelle for your advice, sorry for getting back late, as i spent some time to figure it... but it works well! Thanks again for your help!