Re: Subquery to select max(date) value

On Thu, 28 Mar 2019, Ken Tanzer wrote:

> Really? Is your next_contact field a date field and not a text field? What
> order does it come out in?
>
> (And I assume you saw David J's correction to the misinformation I offered.)

Ken,

Mea culpa. the next_contact column is a date, I did apply David's
correction, and I had a couple of mistaken dates (I had entered 2018 rather
than 2019; the middleware code will check for this error and have the user
correct entries other than the current year).

Regards,

Rich