Php custom date format and comparison

Question

In my database I have one table in which I keep registered users. One column is Date of register and I keep this value in my own string format. For example "[2013-11-30] [19:42:46]"

Then I want to make a check. If user is 30 days old or more. The sure thing is that the above code is wrong. The problem is that if one user registers at 29/01/2015 will not been showing in 30 last days if the current day is 02/02/2015!

//Datetime
   $today = date_parse_from_format("[Y-m-d] [H:i:s]", gmdate("[Y-m-d] [H:i:s]"));
   $store = date_parse_from_format("[Y-m-d] [H:i:s]", $row["LastSeen"]);

   if (
        (($store[year] >= $today[year]) && ($store[month] >= $today[month]))
      )
   { $date_last = "<font color='green'>".$row["LastSeen"]."</font>"; }
   else
   { $date_last = "<font color='red'>".$row["LastSeen"]."</font>"; }

Jon · Accepted Answer · 2015-01-31 15:01:17Z

1

Use date_create_from_format instead of date_parse_from_format. Then you can simply compare the resulting values:

$today = date_create_from_format("[Y-m-d] [H:i:s]", gmdate("[Y-m-d] [H:i:s]"));
$store = date_create_from_format("[Y-m-d] [H:i:s]", $row["LastSeen"]);

if ($store < $today) {
    // ...
}
else {
    // ...
}

answered Jan 31, 2015 at 15:01

Jon

439k85 gold badges756 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stavros Koureas Over a year ago

Thanks but i also tried this and date_create_from_format doesn't work!

Collectives™ on Stack Overflow

Php custom date format and comparison

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related