Bob,
Yay!! A victory for the power of perseverance!
I'm in New Zealand.
Fair enough.
Thought so.
It will help you to be very clear that the format of a date field only
affects the way in which it is displayed, it has no impact at all on the
value stored in the table, which is ultimately what we are working with.
Well, it's actually the number of days since 31 Dec 1899, but apart from
that you'r pretty right. VBA requires dates to be in US format, if they
are expressed as dates, so that's the other way we could have gone, i.e.
to explicitly force the date into mm/dd/yy format. But the method I
suggested just lets it use the actual numerical value of the date data,
which must always be the same regardless of format.
