retrieve the earliest and latest date

[Vanessa]

I'm trying to retrieve 2 dates from a table called
orders. I'm using 2 domain functions using DMin and DMax
to retrieve the 2 dates.

So i.e. DMin("[datesent]","orders"), when running this
function is get #error. Isn't that the right way to
retrieve the earliest date???

Many thanks for any help...

 

[Dirk Goldgar]

I'm trying to retrieve 2 dates from a table called
orders. I'm using 2 domain functions using DMin and DMax
to retrieve the 2 dates.

So i.e. DMin("[datesent]","orders"), when running this
function is get #error. Isn't that the right way to
retrieve the earliest date???

Many thanks for any help...

It looks right to me, so far as it goes -- though you shouldn't have to
put brackets around datesent, as it doesn't contain a space or other
eccentric characters. Where are you using this expression? If it's in
the controlsource of a text box on a form, you should prefix it with an
equals sign; e.g.,

=DMin("datesent","orders")