How can i parse a date to same day of previous month?

Question

How can i parse a date to same day of previous month in PHP?

Example:

   input                 Output

2018-07-25     ->       2018-06-25
2018-07-31     ->       2018-06-30 (because there is no 31)

My code

$d = "2018-07-25";
$xd = date_parse_from_format("y-m-d", $d last month);
$output_d = date_create($xd)->format('Y-m-d');

Check to see if day is 29,30,or 31. If so, make sure the previous month has that day,. If not, go back to the last day of the previous month — John Conde, Jul 11 '18 at 12:38

John Conde · Accepted Answer · 2018-07-11T13:17:02.500

5

<?php
$date = new DateTimeImmutable("2018-07-31");
$previous = $date->sub(new DateInterval('P1M'));
$lastMonth= $date->modify('last day of previous month');
if ($previous > $lastMonth) {
    $previous = $lastMonth;
}
echo $previous ->format('Y-m-d');

This code subtracts one month from the current date. If it is greater than the last day of the previous month we use the last day of the previous month instead.

Demo

edited Jul 11 '18 at 13:17

answered Jul 11 '18 at 13:04

John Conde

217,595
99
455
496

Thanks for this, it help me to create a loop for a entire year. https://sandbox.onlinephpfunctions.com/c/39c3d – Hector Aguero Apr 29 '22 at 19:06

score -2 · Answer 2 · answered Jul 11 '18 at 12:45

-2

Going back to one month is like subtracting one month from the existing date so with the help of strtotime and date we can solve this. like,

$a = "2018-07-25"; $b = date("Y-m-d",strtotime($a."-1 month")); $b is 2018-06-25

Hope this helps.

answered Jul 11 '18 at 12:45

Bannarisamy Shanmugam

112
7

is this return "2018-07-01" when input is "2018-07-31" ? – Rafeeq Mohamed Jul 11 '18 at 12:49
No for exactly 30 days you could use -30 days instead of -1 month – Bannarisamy Shanmugam Jul 11 '18 at 12:53
You can use the following command $b = date("Y-m-d",strtotime($a."-30 days")); – Bannarisamy Shanmugam Jul 11 '18 at 12:58
Neither example you provide works. -30 days on July 31 will be July 1 – John Conde Jul 11 '18 at 12:59
@JohnConde, Have you received the answer for this? if not check with the link https://stackoverflow.com/questions/1889758/getting-last-months-date-in-php . – Bannarisamy Shanmugam Mar 21 '22 at 06:45

How can i parse a date to same day of previous month?

2 Answers2

Linked

Related