What's a function for updating dates like Mother's Day? (1 Viewer)

[MS ACCESS PROBZZZ]

I'm making a press release database which needs to track up coming holidays in order to set reminders. It's easy to enter fixed date holidays. But many of our holidays are on the second Sunday of a month or something like that. So the date changes year to year.

I don't know what the Access object for "day of the week" is. So I don't know how to write a function which requires that.

Can anyone give me an example of what a function like this would look like?

Thanks!

 

[isladogs]

I can't help you with Mother's Day which I believe varies depending on your country location but this thread includes functions for Easter Sunday and for several other holidays

https://access-programmers.co.uk/forums/showthread.php?t=294630

I wrote the Easter Sunday function by adapting some code for Excel written by the late, great Chip Pearson
Compared to Easter, everything else is a 'doddle'

BTW: The function is Weekday and gives a number output compared to a specified start day - by default Sunday is day 1
So a Monday is day 2 etc

 

[MS ACCESS PROBZZZ]

Awesome thank you!

 

[isladogs]

You're welcome.
The Easter code is amazing - I couldn't have written it without Chip's help

Also, see attached for a number of useful date functions compiled by fellow AWF member Pat Hartman

 

[Pat Hartman]

Here's a database with useful date functions. One generates all the dates in a month for a specific weekday.