• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2156
  • Last Modified:

php subtract days from string date

i have a string, in european date format like this: 24/11/2009
i would like to subtract 28 days from the date and as output get a string variable with value 27/10/2009 (output in this format exactly)

i tried smth like the code below, but it does not work, could you please help me get the code right?
date_default_timezone_set('Europe/London');
$mudate = new DateTime("24/11/2009");
date_sub($mudate, new DateInterval("P28D"));

Open in new window

0
KristjanLaane
Asked:
KristjanLaane
  • 3
  • 2
  • 2
2 Solutions
 
RurneCommented:
Several things.

1.  Line 2 can fail, depending on your host.  DateTime expects a string as strtotime() can parse; according to the documentation, that's US English-style, so your switching of days and months might cause some problems.
2.  DateTime::sub doesn't actually modify the original DateTime object, but instead returns a new copy:
<?php
$mudate = new DateTime('2009-11-24', 'Europe/London');
$muinterval = new DateInterval('P28D');
$mudate->sub($muinterval);
echo $mudate->format('d/m/Y')."\n";    // prints '24/11/2009';
$newmudate = $mudate->sub($muinterval);
echo $newmudate->format('d/m/Y')."\n"; // prints '27/11/2009';
?>

Open in new window

0
 
pghnCommented:
Try something like this:

(Since strtotime() I've found to be very good and reliable on parsing any date formate and coming up with the proper timestamp.)
$mudate = new DateTime("24/11/2009");
$newtimestamp = strtotime("-28 days",strtotime($mudate));
$newtimestamp = date("Y-m-d");

Open in new window

0
 
pghnCommented:
Just a correction since you want in the format d/m/Y;

Line 3 it should be:
$newtimestamp = date("d/m/Y");

Open in new window

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
KristjanLaaneAuthor Commented:
the second line of Rurne code and the first line of pghn code causes an error, so the subsequent lines are of no use at the moment. i do not seem to be able to declare a date, do you have ideas how i could get around that?

and not even the following works:


$mudate = date_create('2008-08-03 14:52:10');

Open in new window

0
 
KristjanLaaneAuthor Commented:
might it be because my server is PHP Version 5.0.3 ? I cannot update the version at the moment as im not admin ...
0
 
RurneCommented:
Yes.  DateInterval is not available for versions before 5.3.0.  Your alternative is to work something around strtotime(), get the timestamp, and manipulate it directly.  The below code is a fairly verbose example:
// setting up constants for explanation purposes only
define("SECONDS_PER_MINUTE", 60);
define("MINUTES_PER_HOUR", 60);
define("HOURS_PER_DAY", 24);
 
$day_interval = 28;  // aka DateInterval('P28D');
 
$beginning_timestamp = strtotime('2009-11-24');
$interval = $day_interval * SECONDS_PER_MINUTE * MINUTES_PER_HOUR * HOURS_PER_DAY;
$new_timestamp = $beginning_timestamp - $interval;
echo date('m/d/Y', $new_timestamp)."\n";  // prints "10/27/2009"

Open in new window

0
 
KristjanLaaneAuthor Commented:
thanks, this works great ! strtotime seems to have read the date in in US format, so i changed my initial requirement of european data input and converted it to US date format first.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now