Date of Month

[sbcwebs]

[FONT=Verdana]Is there any way to display a date based upon when it falls in the month? For example, the Second Thursday of the month?

Any help would be appreciated.

Thanks,

Tony[/FONT]

[Installer]

This should do it:

$date = '2006-08-17';

$date_ts = strtotime($date);
$dow = date('l', $date_ts);
$dom = date('j', $date_ts);
$dow_nth = ceil($dom / 7);
$ordinals = array(1 => 'first', 'second', 'third', 'fourth', 'fifth');
echo $date . ' is the ' . $ordinals[$dow_nth] . ' ' . $dow . ' of the month.';

[sbcwebs]

I guess I was unclear as to what I was looking for. I need a script to tell me when the next meeting for an organization will take place. The meetings are on the second Thursday of each month. So for example, I need it to display August 10, 2006 until that date when it should begin displaying September 14, 2006.

[Installer]

That is what you said the first time. I just didn't read carefully enough. Sorry.

This should work:

function next_nth_wkday_ts($n, $day, $add_days = 0)
{
    $wkdays = array('sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday');
    $now = strtotime('today');
    $current_ts = strtotime('+' . $add_days . ' days', $now);
    $first_dom_ts = strtotime(date('Ym01', $current_ts));
    $first_dom_day_num = date('w', $first_dom_ts);
    if (!($day_num = array_search(strtolower($day), $wkdays))) {
        return false;
    }
    $first_day = $day_num - $first_dom_day_num + 1;
    if ($day_num < $first_dom_day_num) {
        $first_day += 7;
    }
    $nth_wkday_ts = strtotime(date('Y-m-' . $first_day, $current_ts) . '+' . ($n - 1) . ' weeks');
    if ($now > $nth_wkday_ts) {
        $nth_wkday_ts = next_nth_wkday_ts($n, $day, date('t', $first_dom_ts));
    }
    return $nth_wkday_ts;
}

Usage:

echo 'Next meeting: ' . date('Y-m-d', next_nth_wkday_ts(2, 'Thursday'));

[sbcwebs]

Thanks! It works Great!!!

[Installer]

Glad to help.

Here's a version that might be (is) better code:

function next_nth_wkday_ts($n, $dow, $add = 0)
{
    $start = strtotime(date('Y-m-01') . ' +' . $add. ' days');
    $curr = $start;
    while (strtolower(date('l', $curr)) !== strtolower($dow)) {
        $curr = strtotime('+1 day', $curr);
        if ($curr >= strtotime('+7 days', $start)) {
            return false;
        }
    }
    $curr = strtotime('+' . ($n - 1) . ' weeks', $curr);
    if ($curr > strtotime('+' . date('t') . ' days', $start)) {
        return false;
    }
    if ($curr < time()) {
        $curr = next_nth_wkday_ts($n, $dow, date('t', $start));
    }
    return $curr;
}

if ($next = next_nth_wkday_ts(2, 'Thursday')) {
    echo 'Next meeting: ' . date('Y-m-d', $next);
} else {
    echo 'Invalid input.';
}

[sbcwebs]

Installer,
The program works great, except on the day of the meeting, I need it to display the current date, not the next meeting. Is there anyway to do that?

[Installer]

Change this line:

if ($curr < time()) {

to:

if (($curr < time()) && (date('Y-m-d', $curr) != date('Y-m-d'))) {

It's not real pretty, but I think it will work.