how to find the second largest date or a number from a field in ac

[Jazz]

I need to find out the previous date than to the maximum date from a date field

 

[Stefan Hoffmann]

hi,

I need to find out the previous date than to the maximum date from a date field

This should do it:

SELECT TOP 1 *
FROM yourTable
WHERE yourDateField < DMax("yourDateField", "yourTable")


mfG
--> stefan <--