PHP get start and end date of a week by weeknumber

Question

I've seen some variants on this question but I believe this one hasn't been answered yet.

I need to get the starting date and ending date of a week, chosen by year and week number (not a date)

example:

input:

getStartAndEndDate($week, $year);

output:

$return[0] = $firstDay;
$return[1] = $lastDay;

The return value will be something like an array in which the first entry is the week starting date and the second being the ending date.

OPTIONAL: while we are at it, the date format needs to be Y-n-j (normal date format, no leading zeros.

I've tried editing existing functions that almost did what I wanted but I had no luck so far.

StackOverflow is not about getting as many variants as possible covered. If you are able to figure out a solution from the variants, don't ask the question. If you couldn't figure it out, you are encouraged to explain how far you've gotten from the variants. — Gordon, Feb 01 '11 at 11:19

score 171 · Answer 1 · answered Dec 16 '13 at 22:30

171

Using DateTime class:

function getStartAndEndDate($week, $year) {
  $dto = new DateTime();
  $dto->setISODate($year, $week);
  $ret['week_start'] = $dto->format('Y-m-d');
  $dto->modify('+6 days');
  $ret['week_end'] = $dto->format('Y-m-d');
  return $ret;
}

$week_array = getStartAndEndDate(52,2013);
print_r($week_array);

Returns:

Array
(
    [week_start] => 2013-12-23
    [week_end] => 2013-12-29
)

Explained:

Create a new DateTime object which defaults to now()
Call setISODate to change object to first day of $week of $year instead of now()
Format date as 'Y-m-d' and put in $ret['week_start']
Modify the object by adding 6 days, which will be the end of $week
Format date as 'Y-m-d' and put in $ret['week_end']

A shorter version (works in >= php5.3):

function getStartAndEndDate($week, $year) {
  $dto = new DateTime();
  $ret['week_start'] = $dto->setISODate($year, $week)->format('Y-m-d');
  $ret['week_end'] = $dto->modify('+6 days')->format('Y-m-d');
  return $ret;
}

Could be shortened with class member access on instantiation in >= php5.4.

answered Dec 16 '13 at 22:30

user3108829

1,711
2
10
3

9

This should be the accepted answer, hands down. It is faster, more clean, and utilizes the internal DateTime() class. – BizLab Jun 04 '14 at 14:50
To note, if you decide to pass back the DateTime object you need to add clone before doing so or you will always get back the modified date. `$ret['week_start'] = clone $dto;` – Styledev Aug 28 '15 at 16:41
3

Because sometimes we need this for mysql, we need the time as well. So I modified this slightly. Reset the time, add 7days and decrease by 1 sec. $dto = new DateTime(); $dto->setISODate($year, $week); $dto->setTime(0,0,0); $ret['week_start'] = $dto->format('Y-m-d H:i:s'); $dto->modify('+7 days'); $dto->modify('-1 sec'); $ret['week_end'] = $dto->format('Y-m-d H:i:s'); – Sándor Tóth Nov 16 '15 at 09:36
Accepted answer is a week off and has some errors in it, this one works – onemesh Oct 08 '17 at 18:03

Roham Rafii · Accepted Answer · 2018-10-25T14:27:20.243

75

Many years ago, I found this function:

function getStartAndEndDate($week, $year) {
  $dto = new DateTime();
  $dto->setISODate($year, $week);
  $ret['week_start'] = $dto->format('Y-m-d');
  $dto->modify('+6 days');
  $ret['week_end'] = $dto->format('Y-m-d');
  return $ret;
}

$week_array = getStartAndEndDate(52,2013);
print_r($week_array);

edited Oct 25 '18 at 14:27

answered Feb 01 '11 at 11:41

Roham Rafii

2,929
7
35
49

score 22 · Answer 3 · answered Apr 21 '16 at 08:54

We can achieve this easily without the need for extra computations apart from those inherent to the DateTime class.

function getStartAndEndDate($year, $week)
{
   return [
      (new DateTime())->setISODate($year, $week)->format('Y-m-d'), //start date
      (new DateTime())->setISODate($year, $week, 7)->format('Y-m-d') //end date
   ];
}

The setISODate() function takes three arguments: $year, $week, and $day respectively, where $day defaults to 1 - the first day of the week. We therefore pass 7 to get the exact date of the 7th day of the $week.

score 12 · Answer 4 · answered Jan 20 '13 at 23:26

Slightly neater solution, using the "[year]W[week][day]" strtotime format:

function getStartAndEndDate($week, $year) {
  // Adding leading zeros for weeks 1 - 9.
  $date_string = $year . 'W' . sprintf('%02d', $week);
  $return[0] = date('Y-n-j', strtotime($date_string));
  $return[1] = date('Y-n-j', strtotime($date_string . '7'));
  return $return;
}

score 6 · Answer 5 · answered Jul 05 '15 at 15:37

6

shortest way to do it:

function week_date($week, $year){
    $date = new DateTime();
    return "first day of the week is ".$date->setISODate($year, $week, "1")->format('Y-m-d')
    ."and last day of the week is ".$date->setISODate($year, $week, "7")->format('Y-m-d'); 
}
echo week_date(12,2014);

answered Jul 05 '15 at 15:37

Claudiu Creanga

8,031
10
71
110

Elegant solution – Florin Nov 08 '22 at 15:32

Nasser Ali Karimi · Answer 6 · 2019-03-05T05:27:53.500

You can get the specific day of week from date as bellow that I get the first and last day

$date = date_create();

// get the first day of the week
date_isodate_set($date, 2019, 1);

    //convert date format and show     
    echo date_format($date, 'Y-m-d') . "\n";

// get the last date of the week
date_isodate_set($date, 2019, 1, 7);

     //convert date format and show        
     echo date_format($date, 'Y-m-d') . "\n";

Output =>

2018-12-31

2019-01-06

score 3 · Answer 7 · answered Aug 12 '19 at 15:16

The "first day of the week" is subjective. Some cultures use "Monday" others "Sunday", maybe others something else?

For my purposes, I want the first day of the week to be "Sunday" and the last day of the week to be "Saturday".

Also, using DateTime with no arguments will default to "now" which includes the current time. The following method will disregard the current time by specifying "today" in the DateTime constructor.

Furthermore the string "sunday this week" does not seem to be reliable. It actually will return Sunday the next week (according to my view of what a week is).

I've built a method which returns a PHP object containing two DateTime objects. One for the first day (Sunday) of the given week, the second for the last day (Saturday) of the given week.

function get_first_and_last_day_of_week( $year_number, $week_number ) {
    // we need to specify 'today' otherwise datetime constructor uses 'now' which includes current time
    $today = new DateTime( 'today' );

    return (object) [
        'first_day' => clone $today->setISODate( $year_number, $week_number, 0 ),
        'last_day'  => clone $today->setISODate( $year_number, $week_number, 6 )
    ];
}

score 2 · Answer 8 · answered Feb 07 '15 at 16:45

The calculation of Roham Rafii is wrong. Here is a short solution:

// week number to timestamp (first day of week number)
function wn2ts($week, $year) {
    return strtotime(sprintf('%dW%02d', $year, $week));
}

if you want the last day of the week number, you can add up 6 * 24 * 3600

score 2 · Answer 9 · answered May 06 '15 at 20:51

This is an old question, but many of the answers posted above appear to be incorrect. I came up with my own solution:

function getStartAndEndDate($week, $year){
    $dates[0] = date("Y-m-d", strtotime($year.'W'.str_pad($week, 2, 0, STR_PAD_LEFT)));
    $dates[1] = date("Y-m-d", strtotime($year.'W'.str_pad($week, 2, 0, STR_PAD_LEFT).' +6 days'));
    return $dates;
}

score 1 · Answer 10 · edited Feb 04 '13 at 09:44

First we need a day from that week so by knowing the week number and knowing that a week has seven days we are going to do so the

$pickADay = ($weekNo-1) * 7 + 3;

this way pickAday will be a day in our desired week.

Now because we know the year we can check which day is that. things are simple if we only need dates newer than unix timestamp We will get the unix timestamp for the first day of the year and add to that 24*3600*$pickADay and all is simple from here because we have it's timestamp we can know what day of the week it is and calculate the head and tail of that week accordingly.

If we want to find out the same thing of let's say 12th week of 1848 we must use another approach as we can not get the timestamp. Knowing that each year a day advances 1 weekday meaning (1st of november last year was on a sunday, this year is on a monday, exception for the leap years when it advances 2 days I believe, you can check that ). What I would do if the year is older than 1970 than make a difference between it and the needed year to know how many years are there, calculate the day of the week as my pickADay was part of 1970, shift it back one weekday for each. $shiftTimes = ($yearDifference + $numberOfLeapYears)%7, in the difference. shift the day backwords $shiftTimes, then you will know what day of the week was that day those years ago, then find the weekhead and weektail. Same thing can be used also for the future if it seems simpler. Try it if it works and tell me if it does not.

Thanks, it sure cleared up some of my confusion about these dates. The answer given by Roham Rafii confirms your theory and I thank you both very much! — Pieter888, Feb 01 '11 at 12:02

score 1 · Answer 11 · answered Jun 28 '18 at 09:44

For documentation (since Google ranks this question first when searching for "php datetime start end this week").

If you need the startdate and enddate for the current week (using DateTime):

$dateTime = new DateTime('now');
$monday = clone $dateTime->modify(('Sunday' == $dateTime->format('l')) ? 'Monday last week' : 'Monday this week');
$sunday = clone $dateTime->modify('Sunday this week');

var_dump($monday->format('Y-m-d')); // e.g. 2018-06-25
var_dump($sunday->format('Y-m-d')); // e.g. 2018-07-01

Hope this will help.

score 1 · Answer 12 · answered May 13 '23 at 18:56

Get the date using weeknumber, this is my example for all year.

<?php
   $year = "2023";
   for($i = 1; $i <= 52; $i++){
       print_r([
          (new DateTime())->setISODate($year, $i)->format('Y-m-d'), //start date
          (new DateTime())->setISODate($year, $i, 7)->format('Y-m-d') //end date
      ]);
  }
?>

score 0 · Answer 13 · answered Aug 14 '13 at 18:44

0

function getStartAndEndDate($week, $year)
    {
        $week_start = new DateTime();
        $week_start->setISODate($year,$week);
        $return[0] = $week_start->format('d-M-Y');
        $time = strtotime($return[0], time());
        $time += 6*24*3600;
        $return[1] = date('d-M-Y', $time);
        return $return;
    }

answered Aug 14 '13 at 18:44

CBSUA

11

explain what you did a bit futher than simply posting the code – Rémi Aug 14 '13 at 19:01

score 0 · Answer 14 · answered Feb 01 '11 at 10:33

0

Have you tried PHP relative dates? It might work.

answered Feb 01 '11 at 10:33

Mikel

24,855
8
65
66

then what command would you suggest I use? `strtotime('first day of week 12')`? – Pieter888 Feb 01 '11 at 10:56
1

Perhaps you can chain them. Try `+n weeks` to get the week. Then look at the docs again. There is also a way to get a weekday. – Mikel Feb 01 '11 at 12:05

score 0 · Answer 15 · answered Feb 01 '11 at 11:26

Even if you dont want to use a specific date you cannot escape it. You can calculate a week based on the date ONLY.

Steps:

get the first day of the year
decide when the first week starts ( there are some rules that include first Thursday if I remember.
add some number of weeks (your first param). Zend_Date has an add() function where you can add weeks for example. This will give you the first day of the week.
offset and get the last day.

I would recommend working with a consistent dates sistem like Zend_Date or Pear Date.

score 0 · Answer 16 · answered Jun 21 '18 at 09:28

$dateParam = '2018-06-10';
$week = date('w', strtotime($dateParam));
$date = new DateTime($dateParam);
$firstWeek = $date->modify("-".$week." day")->format("Y-m-d H:i:s");
$endWeek = $date->modify("+6 day")->format("Y-m-d H:i:s");
echo $firstWeek."<br/>";
echo $endWeek;

will print

2018-06-10 00:00:00
2018-06-16 00:00:00

hopefully will help

score -1 · Answer 17 · answered May 30 '23 at 10:36

In many cases input fields comes from a form and is week type:

<html>
<input type="week" name="weekDate">
</html>

<?php 
    $postDate = $_POST['weekDate'];
    $date = new DateTime($postDate );
    $startDate = $date->format('Y-m-d');
    $date->modify('+6 day');
    $endDate = $date->format('Y-m-d');
?>

or

<?php 
function getDatesFromWeek($weekDate){
    $date = new DateTime($weekDate);
    $startDate = $date->format('Y-m-d');
    $date->modify('+6 day');
    $endDate = $date->format('Y-m-d');
    return $dates[] = ['startDate'=>$startDate, 'endDate'=>$endDate];
}
?>

Your answer shares the same code with the 2 top answers while also adding something unrelated to the original question. — Slavic, May 30 '23 at 13:02

PHP get start and end date of a week by weeknumber

17 Answers17

Linked

Related