There are a ton of such questions on Stackoverflow and before you mark this as duplicate, let me tell you that none of those work in my case.
Date Difference in php on days?
Calculate the difference between date/times in PHP
Dates difference with php
Finding the number of days between two dates
How to calculate the difference between two dates using PHP?
Above are the questions I have checked. The last question has an answer by
Jurka which also unfortunately doesn't works. So here is my code:
$date1 = new DateTime(date('d-m-y'));
$date2 = new DateTime($etaDate);
$interval = $date1->diff($date2);
echo "difference " . $interval->days . " days ";
$etaDate in above case is 03-02-16 and the current date is 08-02-16 so it should return 5 days but it returns a very high figure - 1826 days. I have tried different methods which also returns the same day figure.
A date value is stored as string in database so on retrieving I am again putting it back to date format using this code:
$newdate = DateTime::createFromFormat('d-m-y', $EntryDate);
$etaDate = $newdate->format('d-m-y');
$EntryDate is a variable that holds the date from the database,
$etaDate converts it into date format.