Get first and last day from last month

Question

I have this:

$today=date('Y-m-d');
// echo "2013-11-12";

I want to get the last month range like this:

$startLastMonth = "2013-10-01";
$endLastMonth   = "2013-10-31";

I try that but it's does not meet my desire as I need to put 42:

$startLastMonth = mktime(0, 0, 0, date("Y"), date("m"),   date("d")-42);

Is there another way ?

Thanks

http://stackoverflow.com/questions/1686724/php-last-day-of-the-month — Dennis Hunink, Nov 12 '13 at 17:38
@wumm OP wants first and last day from last month and not for current month. — skjcyber, Nov 12 '13 at 17:39
@Marcell Fülöp: Not clear. Haha. Try to read it again. You are the only one who not understand it as others gave me an advice. — user2984349, Nov 12 '13 at 17:41
-1 Please use the SO site search first, there are at least two identical duplicates… — feeela, Nov 12 '13 at 17:47
Just use `Y-m-t` format to get last date of the month, and close this question for duplicate. — Glavić, Nov 12 '13 at 18:37

Alexander Kuzmin · Accepted Answer · 2013-11-12T17:54:30.867

4

The code below should work

$startLastMonth = mktime(0, 0, 0, date("m") - 1, 1, date("Y"));
$endLastMonth = mktime(0, 0, 0, date("m"), 0, date("Y"));

What you're doing is telling PHP that a) you want the 1st day of the previous month (date("m") - 1), and b) telling PHP you want the 0th day of the current month, which, according to mktime documentation, becomes the last day of the previous month. Documentation can be found here: http://php.net/manual/en/function.mktime.php

If you want to format the output as in your you can do

$startOutput = date("Y-m-d", $startLastMonth);
$endOutput = date("Y-m-d", $endLastMonth);

edited Nov 12 '13 at 17:54

answered Nov 12 '13 at 17:38

Alexander Kuzmin

1,120
8
16

The output (`2013-10-01` and `2013-10-31`) will be in the `$startOutput` and `$endOutput` variables. – Alexander Kuzmin Nov 12 '13 at 17:43
I've for $startOutput: 2168-09-10... – user2984349 Nov 12 '13 at 17:48
Oops, got the wrong order for the arguments! It should work now! :) – Alexander Kuzmin Nov 12 '13 at 17:54

score 3 · Answer 2 · answered Nov 12 '13 at 17:44

3

Just use the relative date/time formats that are provided by PHP:

var_dump( new DateTime( 'first day of last month' ) );
var_dump( new DateTime( 'last day of last month' ) );

See: http://www.php.net/manual/en/datetime.formats.relative.php

answered Nov 12 '13 at 17:44

feeela

29,399
7
59
71

vascowhite · Answer 3 · 2013-11-12T18:04:01.900

0

Here's a handy little function that will do what you want. You will get back an array containing the first and last days of the previous month to the date supplied:-

function getLastMonth(DateTime $date)
{
    //avoid side affects
    $date = clone $date;
    $date->modify('first day of last month');
    return array(
        $date->format('Y-m-d'),
        $date->format('Y-m-t'),
    );
}

var_dump(getLastMonth(new \DateTime()));

Output:-

array (size=2)
  0 => string '2013-10-01' (length=10)
  1 => string '2013-10-31' (length=10)

In PHP > 5.3 you can do this:-

list($start, $end) = getLastMonth(new \DateTime());
var_dump($start, $end);

Output:-

string '2013-10-01' (length=10)
string '2013-10-31' (length=10)

See it working.

edited Nov 12 '13 at 18:04

answered Nov 12 '13 at 17:50

vascowhite

18,120
9
61
77

Thanks but why make it hard for nothing? date("Y-m-d", mktime(0, 0, 0, date("m")+1, 1, date("Y"))) made the job. – user2984349 Nov 12 '13 at 17:53
Yes, but mktime will not allow for leap years and DST changes. This will. – vascowhite Nov 12 '13 at 17:54
Are you sure mktime won't work like that? – Alexander Kuzmin Nov 12 '13 at 17:55
Yes, reasonably sure, although I'm always prepared to be proved wrong. – vascowhite Nov 12 '13 at 18:04

Get first and last day from last month

3 Answers3