i created a report that has datetime columns for certain events. i created a datediff formula to get the time difference (in minutes) between two events.  Say we have one transaction with transaction number 0001. Transaction 0001 has 4 rows, each with different values for EVENT1 (datetime), BUT the same values for EVENT2.  Now I want to show only the row with the smallest datediff value, the problem is there are datediff results with negative values and when i try to get the Nthsmallest it will include the negative value, and i only want the lowest positive value to show. is there a way i can do that? Thanks very much! my knowledge of crystal report is very basic only.

hello lockwelle thanks for the suggestion, i tried it but it returned a boolean ..
i did it this way
NumberVar X := datediff ("n",{table.EVENT1},{table.EVENT2});

    if x < 0 then x = 1000

i think i did something wrong....

i missed the colon. thanks! worked perfectly!! keep up the good work!

Edited by iami21 - 23 Jul 2009 at 2:13am