3rd Friday (1 Viewer)

[john@jbward.co.uk]

I am trying to produce an agenda for an organisation that has a number of branches, each branch has between 4 to 10 meetings per year depending on the branch.

The meetings can be any day of the week any week in the month and any months in the year.

I need a code to produce the date from any day week and month.

For example the date for the second Tuesday in February or the first Friday in March.

I have combo boxes that produce today number the week number in the month number

Any help would be appreciated

 

[Gasman]

Post #5 in this thread https://www.access-programmers.co.u...g-dates-like-mothers-day.300480/#post-1583388 has a DB created by @Part Hartman that has a lot of useful functions. See if any of those are useful to you.

 

[arnelgp]

is the demo same as you want?

 

[Pat Hartman]

Look at the code behind the first weekday tab in my useful date functions database at the link Gasman posted. That might help you.