How to get a day of month from "what I know"?

Question

Need some logic here:

Need to get day of month date("d")

What I know:

$year = 2013;
$month = 10;
$week_nr_of_month = 3; // from 1 to 6 weeks in month
$day_of_week = 0; // Sunday date("w")

Thanks for logic

Result must be: 13 October

Just calculate a day of month (1 to 31) , using that variables. — jmp, Feb 01 '14 at 00:39
You should try it yourself and afterwards you can come up with some code for us to help you out — Reger, Feb 01 '14 at 00:41

score 0 · Answer 1 · answered Feb 01 '14 at 00:41

0

strtotime may be of help. Can't test right now, but...

$ordinal = array("first","second","third","fourth","fifth");
$weekdays = array("monday","tuesday","wednesday","thursday","friday","saturday","sunday");
$timestamp = strtotime($year."-".$month." ".$ordinal[$week_nr_of_month]." ".$weekdays[$day_of_week]);

answered Feb 01 '14 at 00:41

Niet the Dark Absol

320,036
81
464
592

almost but no.. it's shows 28 October, but need 13 October – jmp Feb 01 '14 at 00:46
Hmm... try moving "sunday" to the front of the array, and subtract one from the week number... – Niet the Dark Absol Feb 01 '14 at 00:46

score 0 · Accepted Answer · edited May 23 '17 at 12:21

0

This was fun to figure out.

<?php

$year = 2013;
$month = 10;
$week_nr_of_month = 3; // from 1 to 6 weeks in month
$day_of_week = 0; // Sunday date("w")

$start = new DateTime();
$start->setDate($year, $month, '1');
$end = clone $start;
$end->modify('last day of this month');
$interval = new DateInterval('P1D');
$period = new DatePeriod($start, $interval, $end);

foreach ($period as $date) {
    if ($date->format('w') == $day_of_week) {
        $wom = week_of_month($date->format('Y-m-d'));
        if ($week_nr_of_month == $wom) {
            echo $date->format('Y-m-d');
        }
    }
}

function week_of_month($date) {
    $dt = new DateTime($date);
    $bg = clone $dt;
    $bg->modify('first day of this month');
    $day_of_first = $bg->format('N');
    $day_of_month = $dt->format('j');
    return floor(($day_of_first + $day_of_month - 1) / 7) + 1;
}

See it in action

Used this answer for inspiration to get the week number for the date.

edited May 23 '17 at 12:21

Community

1
1

answered Feb 01 '14 at 00:47

John Conde

217,595
99
455
496

I'm off by a week so far. Gotta find a better way to narrow down the actual week. – John Conde Feb 01 '14 at 00:52
yeah, result must be 13 october – jmp Feb 01 '14 at 00:53
no, not working correct for other dates.. for example: Year 2014, month: 1, week nr of month: 3, day of week = 0, showing: 2014-01-12 , must be 2014-01-09 – jmp Feb 01 '14 at 01:05
2014-01-12 is the correct response. You can verify it by looking at a calendar. – John Conde Feb 01 '14 at 01:08
wow sorry you right. i just sleepy and didnt sow that now is first feb. – jmp Feb 01 '14 at 01:09
No problem. That was an interesting challenge. – John Conde Feb 01 '14 at 01:13

How to get a day of month from "what I know"?

2 Answers2