Search results

Okay, here's my tweak, a composite of all the knowledge and help from all of you guys. I've quoted my sources in code, but it's really thanks to everyone in the post thread(s) This I made into a module: Public Function nthDay(nDATE As Date, nWoM As Integer, nDoW As Integer) As Variant '...

To jdraw, Yes November has only 4 weeks, but the 4th week is ALSO the last week, the qualifier here is the last week and not the 4th week.

Yes... the difficulty here for me is understanding how to compute where it's not a straight forward 4 weeks per month, depending on week day and what day the 1st of the month is in the starting month... at least I think that's how the logic goes, right?

To theDBGuy, The example is as follows: If today is Wednesday, July 31, 2019, it is ALSO the 5th or last Wednesday of July. The user would need the last Wednesday in 4, 5, or 6 months. If today was Wednesday, July 24, 2019 it would ALSO be the 4th (but NOT LAST) Wednesday of July. The user...

I got a sample code from Mr. Dale Fye on utter access that gave me more insight for me to be able to to do what I need. Once I have compiled my adaption, I will post and let you guys give input.

To give a better understanding of my issue, the user has to give a date 3, 4, 5, 6 sometimes 7 months in advance of today's date. A simple DateAdd didnot work beyond 2 months.... so I started to really look at what was needed. After all the input for the last 2 days ( and one sleepless night, I...

Okay. So, first of all, thanks to all of you for the input to my question. It was never my intention to ignore anyone who is trying to help me, but in the RL, things get complicated sometimes... I have tried out the different suggestions and yes I was able to get to follow most of the...

Lots of good stuff, but not applicable. Most of them are the REVERSE, as in, what date is the nth day of the month?

Thanks for the info, but this doesn't actually address the need. In code, Date () returns today's date. What I'm looking for Date()= 3rd Monday of the July (as an example).

Greetings to all! This is my first post. (Yes I know that I joined a while ago, but most of my questions before were answered by someone or somewhere so I didn't see the need). Having spent the last 3 days searching, I have to ask: As a newbie to Access programming (less than 2 years of...