In PHP, is there an easy way to get the first and last date of a month?

Question

I need to get the first and last day of a month in the format YYYY-MM-DD given only the month and year. Is there a good, easy way to do this?

I feel kind of stupid for asking for the first day of a month....:\ — Thomas Owens, Sep 04 '08 at 12:22

score 64 · Accepted Answer · answered Sep 04 '08 at 12:22

64

$first = date('Y-m-d', mktime(0, 0, 0, $month, 1, $year));
$last = date('Y-m-t', mktime(0, 0, 0, $month, 1, $year));

See date() in PHP documentation.

answered Sep 04 '08 at 12:22

Michał Niedźwiedzki

12,859
7
45
47

1

what is "1" after $month? – FosAvance Dec 09 '13 at 22:13
didn't realize you could make such a brillant solution just by adding "t". Clean and simple. – Limon May 27 '15 at 19:53

score 7 · Answer 2 · answered Sep 04 '08 at 12:21

7

First day is always YYYY-MM-01, isn't it? Example: date("Y-M-d", mktime(0, 0, 0, 8, 1, 2008))

Last day is the previous day of the next month's first day:

$date = new DateTime("2008-09-01");
$date->modify("-1 day");
echo $date->format("Y-m-d");

answered Sep 04 '08 at 12:21

Biri

7,101
7
38
52

score 3 · Answer 3 · answered Sep 04 '08 at 12:21

3

The first day of the month is always 1. So it will become

YYYY-MM-01

the last day can be calculated as:

<?php
    $num = cal_days_in_month(CAL_GREGORIAN, 8, 2003); // 31
    echo "There was $num days in August 2003";
?>

answered Sep 04 '08 at 12:21

Niyaz

53,943
55
151
182

score 2 · Answer 4 · edited Sep 04 '08 at 12:42

2

OK, first is dead easy.

date ('Y-m-d', mktime(0,0,0,MM,01,YYYY));

Last is a little trickier, but not much.

date ('Y-m-d', mktime(0,0,0,MM + 1,-1,YYYY));

If I remember my PHP date stuff correctly...

**edit - Gah! Beaten to it about a million times...

Edit by Pat:

Last day should have been

date ('Y-m-d', mktime(0,0,0,$MM + 1,0,$YYYY)); // Day zero instead of -1

edited Sep 04 '08 at 12:42

Pat

36,282
18
72
87

answered Sep 04 '08 at 12:23

ZombieSheep

29,603
12
67
114

score 2 · Answer 5 · answered Feb 10 '12 at 09:19

2

<?php
echo "Month Start - " . $monthStart = date("Y-m-1") . "<br/>";
$num = cal_days_in_month(CAL_GREGORIAN, date("m"), date("Y"));
echo "Monthe End - " . $monthEnd = date("Y-m-".$num);
?>

answered Feb 10 '12 at 09:19

Eranda

868
1
10
27

score 1 · Answer 6 · 2013-05-17T07:38:20.943

The easiest way to do this with PHP is

$dateBegin = strtotime("first day of last month");  
$dateEnd = strtotime("last day of last month");

echo date("MYDATEFORMAT", $dateBegin);  
echo "<br>";        
echo date("MYDATEFORMAT", $dateEnd);

Or the last week

if (date('N', time()) == 7) {
$dateBegin = strtotime("-2 weeks Monday");
$dateEnd = strtotime("last Sunday");
} else {
$dateBegin = strtotime("Monday last week"); 
$dateEnd = strtotime("Sunday last week");   
}

Or the last year

$dateBegin = strtotime("1/1 last year");
$dateEnd = strtotime("12/31 this year");

score 0 · Answer 7 · answered Jul 13 '13 at 04:54

0

try this to get the number of days in the month:

$numdays = date('t', mktime(0, 0, 0, $m, 1, $Y));

answered Jul 13 '13 at 04:54

Nate

579
1
7
14

score 0 · Answer 8 · answered Jan 09 '15 at 08:37

Example; I want to get first day and last day of current month.

$month   = (int) date('F');
$year    = (int) date('Y');

date('Y-m-d', mktime(0, 0, 0, $month + 1, 1, $year)); //first
date('Y-m-d', mktime(0, 0, 0, $month + 2, 0, $year)); //last

When you run this for instance at date 2015-01-09, the first and last values will be sequentially;

2015-01-01
2015-01-31

Tested.

score 0 · Answer 9 · answered Sep 04 '08 at 12:35

0

By the way @ZombieSheep solution

date ('Y-m-d', mktime(0,0,0,$MM + 1,-1,$YYYY));

does not work it should be

date ('Y-m-d', mktime(0,0,0,$MM + 1,0,$YYYY)); // Day zero instead of -1

Of course @Michał Słaby's accepted solution is the simplest.

answered Sep 04 '08 at 12:35

Pat

36,282
18
72
87

arturwwl · Answer 10 · 2018-01-05T10:53:40.597

From here(get next month last day) that is marked as duplicated, so i can't add comment there, but people can got bad answers from there.

Correct one for last day of next month:

echo ((new DateTime(date('Y-m').'-01'))->modify('+1 month')->format('Y-m-t'));

Correct one for first day of next month:

echo ((new DateTime(date('Y-m').'-01'))->modify('+1 month')->format('Y-m-01'));

Code like this will be providing March from January, so that's not what could be expected.

echo ((new DateTime())->modify('+1 month')->format('Y-m-t'));

score 0 · Answer 11 · answered Sep 08 '08 at 16:13

Just to verify that I didn't miss any loose ends:

$startDay = 1;

if (date("m") == 1) {
    $startMonth = 12;
    $startYear = date("Y") - 1;

    $endMonth = 12;
    $endYear = date("Y") - 1;
}
else {
    $startMonth = date("m") - 1;
    $startYear = date("Y");

    $endMonth = date("m") - 1;
    $endYear = date("Y");
}

$endDay = date("d") - 1;

$startDate = date('Y-m-d', mktime(0, 0, 0, $startMonth , $startDay, $startYear));
$endDate = date('Y-m-d', mktime(0, 0, 0, $endMonth, $endDay, $endYear));

score 0 · Answer 12 · answered Dec 30 '21 at 11:29

proper way to build a relative date from now is:

//bad example - will be broken when generated at 30 of December (broken February)
    echo date("Y-m-d", strtotime("now"))."\n";
    echo date("Y-m-d", strtotime("now + 1 month"))."\n";
    echo date("Y-m-d", strtotime("now + 2 month"))."\n";
    echo date("Y-m-d", strtotime("now + 3 month"))."\n";
    
//good example, you can change first day to last day or any day
    echo date("Y-m-d", strtotime("first day of this month"))."\n";
    echo date("Y-m-d", strtotime("first day of next month"))."\n";
    echo date("Y-m-d", strtotime("first day of +2 month"))."\n";
    echo date("Y-m-d", strtotime("first day of +3 month"))."\n";

and the result will be:

In PHP, is there an easy way to get the first and last date of a month?

12 Answers12

Linked

Related