Return Previous Date

[RonAle]

Hello,
I'm basically trying to return date before the DMax date.

for example if My table has a date field with these values

1. 4/25/07
2. 4/22/07
3. 4/19/07
4. 4/12/07

how would I return the value 4/22/07?

 

[PWise]

dmax("datefield","tablename", "start not in (Select max(datefield)from tablename)")

 

[PWise]

sorry
sb
dmax("datefield","tablename", "datefield not in (Select max(datefield)from tablename)")

 

[RonAle]

Perfect.. thanks a bunch