[SamirDarji]

Awesome! Thank you very much. I've run it a few times manually to see how it worked. Really sweet.

I was looking at the code and I noticed it's using 30 days for the month, which generally works, but I wanted to see if there was a way to get it to be precisely the number of days in a month. I found the date('t') function on php.net that seems like it will return the number of days in the current month which could be used to calculate the exact number of seconds in that month.

The only problem is that vb's cron doesn't have a setting to run at the end of the month. A quick google search came up with some exotic cron lines that I'm not familar with nor know how to implement. So the other option would be to execute the script in two different crons in vb, once for the end of the week, once for the first of the month, and if the script detects that it's running at the first of the month that's not the end of the week, subtract a day and then calculate the month via that time and determine the random user.

But the more I think about this, since the week or month would be executed separately in two different crons, maybe the script should just be croned to run daily and do its own end of week and end of month detection and execute accordingly. Then the cron variable is taken out of the picture.

So the whole body of the script could be two if statements. If today is last day of month, execute for last day of month and email. If today is last day of the week, excute for end of the week and email. If it doesn't fall into either loop, the cron will execute with no output. But looking at the structure of your cron, it's designed to execute both queries back to back from an array, so the main loop would change. Would it be too much to ask for this design change?

I've figured out that

if(date('j') == date('t'))

can be used to check eom and

if(date('N') == 7)

should be able to be used to check eow. But this research has taken me over an hour.