Hi,

(This is my first posting on this group, so forgive my newbie-ness.)

Can anyone help with the following example:

I have an event that occurs on the first wednesday of january every
year.
So this year: EventDate = 06/01/1999

How do I calculate next years EventDate ? (Obviously adding 1 year is
not the solution.)

ANY information would be appreciated.

Thanks,
Graeme.

Hi Graeme -

Use the Weekday function to return the day of the week - by default the
weekday function uses Sunday as day 1, so you will be testing for day 4.

If day(now) < 7 and Month(Now) = 1 Then
    ' Is in first week of first month
    If Weekday(Now) = 4 Then
       ' Is First Wednesday
    End If
End If

This should work - I haven't tested it - but if it doesn't then shout.

Regards

Stuart
London

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---