Trevor Best <no****@besty.org.uk> wrote in message news:<41***********************@news.zen.co.uk>...
I'm sure there's a mathmatical way but I can't think of one right now,
so here's a brute force way.
IIf(Month > 8, Month - 8, Month + 4)
Month(DateAdd("m", 4, dtTestDate))
or
(Month(dtTestDate) + 3) Mod 12 + 1
should also work. BTW, Trevor, does the botanical garden in Cambridge
still have the Fortune Palm there?
James A. Fortune
The word query derives from Latin "perquirere" which means "to
search for thoroughly." --
www.m-w.com (Merriam-Webster Online)