Find next date in table

George_Hepworth 

They are just dates stored in a date field in a table.


It's simple to do in a query
SELECT TOP 1 tbl_dates.My_date
FROM tbl_dates
WHERE (((tbl_dates.My_date)>Date()))
ORDER BY tbl_dates.My_date;

Or in a form you can use
DMin("my_date", "tbl_dates", "my_date > Date()")

But I was hoping for a form textbox simple expression
e.g.
=DMax("my_date","tbl_dates")
=DMin("my_date","tbl_dates")

LoL
Mind you it may not be possible.  I'm sure there isn't a DNext