Work out difference between 2 dates in days

Question

I have two dates. One of them is the current date, one of them is a date somebody uploaded something, this is stored in a database. I need to find out if the date stored in the database is older than 7 days from the current date. I'm using PHP's date(d/m/y);, I've tried some things online, I've tried dateDifference() from php.net, I've tried converting them to timestamps and taking them away, but neither of these seem to work. Is there a simpler way?

Please revise your question with a verifiable problem, showing the code you used. Right now we have to guess at the end result you want and have no context on how your dates are stored in the database. For all intents and purposes, this can also be performed in mysql using See: [`DATEDIFF(NOW(), date_column)`](http://sqlfiddle.com/#!9/ed654b/1) — Will B., Mar 16 '18 at 23:32

score 0 · Answer 1 · answered Mar 16 '18 at 23:18

0

This is what carbon is made for. Consider it.

        //time in db is in this format 2018-03-16 08:31:09 for this example
        $dateInDb = Carbon::createFromFormat("Y-m-d H:i:s",$timeInDb);
        $days = Carbon::now()->diffInDays($dateInDb);

Check the library here

answered Mar 16 '18 at 23:18

Toby Okeke

624
3
13

4

No need of Carbon to check the difference between two dates. See @Jeto comment. – Syscall Mar 16 '18 at 23:29

score 0 · Answer 2 · answered Mar 16 '18 at 23:38

try this:

<?php
$upload_date = '09/03/2018'; # d/m/Y format
if (strtotime(date_format(date_create_from_format('d/m/Y',$upload_date),'Y-m-d')) < strtotime('-7 days')) {
    echo 'Upload date is older than 7 days ago.';
} else {
    echo 'Upload date is not older than 7 days ago.';
}

Work out difference between 2 dates in days

2 Answers2