How to get End Date from Adding Start Date with Duration Count?
I have table which has the table field name:
- Start Date
- Duration Count (e.g. 1, 2 or 3)
- Duration Name (e.g. Daily, Monthly, Yearly)
- End Date
How do I code in PHP to calculate the end date from a particular start date?
E.g. The start date is on 1st January 2013, and duration count is 1, duration name is yearly.
Which actually meant to be 1 year duration. How do I code in order to get the answer of
31st December 2013 in my end date column?
Example Formula: $StartDate + $DurationCount & $DurationName = $EndDate?
Noticed that I'm facing the problem when it comes to monthly issues. For example is an invoice bill
starts on 31st January 2013, after one month the bill supposed to be due in March. It matters when
whether 2013 is a lear year or non leap year.
$nextWeek = date('Y-m-d', strtotime('+1 week'));
[CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]
If you can't think outside the box, you will be trapped forever with no escape...
Just to expand a bit on the above example (because it's lunch time ):
$StartDate + $DurationCount & $DurationName = $EndDate?
$endDate = date('Y-m-d 00:00:00', strtotime("+$durationCount $durationName", strtotime("$startDate 00:00:00")));
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)