Results 1 to 3 of 3

Thread: How to get End Date from Adding Start Date with Duration Count?

  1. #1
    Join Date
    Jul 2013

    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.

  2. #2
    Join Date
    Mar 2007

    PHP Code:
    $nextWeek date('Y-m-d'strtotime('+1 week'));

    --> JavaScript Frameworks like JQuery, Angular, Node <--
    ... and please remember to wrap code with forum BBCode tags:-

    [CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]

    If you can't think outside the box, you will be trapped forever with no escape...

  3. #3
    Join Date
    Aug 2004
    Just to expand a bit on the above example (because it's lunch time ):
    PHP Code:
    $StartDate $DurationCount $DurationName $EndDate?
    $endDate date('Y-m-d 00:00:00'strtotime("+$durationCount $durationName"strtotime("$startDate 00:00:00"))); 
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center