Increment Date by One Month

increment date by one month

$time = strtotime("2010.12.11");
$final = date("Y-m-d", strtotime("+1 month", $time));

// Finally you will have the date you're looking for.

How to increment date by one month in laravel?

You have the same Carbon instance all the time, so you need to store the formatted start and end dates:

$date = $wallet_master->created_at;
$startMonth = $date->format('d-m-Y');
// 31-5-2022
$endMonth = $date->addDays(30)->format('d-m-Y');
//30-6-2022

for ($i = 0; $i < $wallet_package->wallet_duration; $i++) {

    $data = [   
         'start_date' => $startMonth,
         'end_date' =>   $endMonth,
    ];

    DB::table('wallet_table')->insert($data);
    $startMonth = $date->addDays(1)->format('d-m-Y');
    $endMonth =  $date->addDays(30)->format('d-m-Y');
}

Is there a simple way to increment a datetime object one month in Python?

Check out from dateutil.relativedelta import *
for adding a specific amount of time to a date, you can continue to use timedelta for the simple stuff i.e.

import datetime
from dateutil.relativedelta import *
use_date = datetime.datetime.now()

use_date = use_date + datetime.timedelta(minutes=+10)
use_date = use_date + datetime.timedelta(hours=+1)
use_date = use_date + datetime.timedelta(days=+1)
use_date = use_date + datetime.timedelta(weeks=+1)

or you can start using relativedelta

use_date = use_date+relativedelta(months=+1)

use_date = use_date+relativedelta(years=+1)

for the last day of next month:

use_date = use_date+relativedelta(months=+1)
use_date = use_date+relativedelta(day=31)

Right now this will provide 29/02/2016

for the penultimate day of next month:

use_date = use_date+relativedelta(months=+1)
use_date = use_date+relativedelta(day=31)
use_date = use_date+relativedelta(days=-1)

last Friday of the next month:

use_date = use_date+relativedelta(months=+1, day=31, weekday=FR(-1))

2nd Tuesday of next month:

new_date = use_date+relativedelta(months=+1, day=1, weekday=TU(2))

As @mrroot5 points out dateutil's rrule functions can be applied, giving you an extra bang for your buck, if you require date occurences.

for example:

Calculating the last day of the month for 9 months from the last day of last month.

Then, calculate the 2nd Tuesday for each of those months.

from dateutil.relativedelta import *
from dateutil.rrule import *
from datetime import datetime
use_date = datetime(2020,11,21)

#Calculate the last day of last month
use_date = use_date+relativedelta(months=-1)
use_date = use_date+relativedelta(day=31)

#Generate a list of the last day for 9 months from the calculated date
x = list(rrule(freq=MONTHLY, count=9, dtstart=use_date, bymonthday=(-1,)))
print("Last day")
for ld in x:
    print(ld)

#Generate a list of the 2nd Tuesday in each of the next 9 months from the calculated date
print("\n2nd Tuesday")
x = list(rrule(freq=MONTHLY, count=9, dtstart=use_date, byweekday=TU(2)))
for tuesday in x:
    print(tuesday)

Last day
2020-10-31 00:00:00
2020-11-30 00:00:00
2020-12-31 00:00:00
2021-01-31 00:00:00
2021-02-28 00:00:00
2021-03-31 00:00:00
2021-04-30 00:00:00
2021-05-31 00:00:00
2021-06-30 00:00:00

2nd Tuesday
2020-11-10 00:00:00
2020-12-08 00:00:00
2021-01-12 00:00:00
2021-02-09 00:00:00
2021-03-09 00:00:00
2021-04-13 00:00:00
2021-05-11 00:00:00
2021-06-08 00:00:00
2021-07-13 00:00:00

rrule could be used to find the next date occurring on a particular day.

e.g. the next 1st of January occurring on a Monday (Given today is the 4th November 2021)

from dateutil.relativedelta import *
from dateutil.rrule import *
from datetime import *
year = rrule(YEARLY,dtstart=datetime.now(),bymonth=1,bymonthday=1,byweekday=MO)[0].year
year
2024

or the next 5 x 1st of January's occurring on a Monday

years = rrule(YEARLY,dtstart=datetime.now(),bymonth=1,bymonthday=1,byweekday=MO)[0:5]
for i in years:print(i.year)
... 
2024
2029
2035
2046
2052

The first Month next Year that starts on a Monday:

>>> month = rrule(YEARLY,dtstart=datetime.date(2023, 1, 1),bymonthday=1,byweekday=MO)[0]
>>> month.strftime('%Y-%m-%d : %B')
'2023-05-01 : May'

If you need the months that start on a Monday between 2 dates:

months = rrule(YEARLY,dtstart=datetime.date(2025, 1, 1),until=datetime.date(2030, 1, 1),bymonthday=1,byweekday=MO)
>>> for m in months:
...     print(m.strftime('%Y-%m-%d : %B'))
... 
2025-09-01 : September
2025-12-01 : December
2026-06-01 : June
2027-02-01 : February
2027-03-01 : March
2027-11-01 : November
2028-05-01 : May
2029-01-01 : January
2029-10-01 : October

This is by no means an exhaustive list of what is available.
Documentation is available here: https://dateutil.readthedocs.org/en/latest/

How to increment date by one month in JavaScript? Receiving Uncaught TypeError

jQuery .val() returns a string, which then has to be parsed. The code below assumes that it actually is in a format that can be parsed. Best to use yyyy-mm-dd.

Furthermore it is important to know that date.setMonth(...) changes the underlying date object.

Also note that 'impossible dates' are rolled over into the next month, e.g. doing date.setMonth(11) on a source date of 2018-10-31 will result in the 'impossible date' 2018-11-31, which then becomes 2018-12-01.

Demo:

function getNewDate() {

  var str = $("#selectedDate").val(); // get string

  console.log(str);

  var date = new Date(str); // parse string

  console.log(date);

  date.setMonth(date.getMonth() + 1); // change date

  console.log(date);

}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<input id="selectedDate" value="2018-12-20" />

<button onclick="getNewDate()">Add month</button>

How to increase date by one month from fetched date from the database in php

Try this

$regdate = strtotime($row2['created_date']);
echo date('Y-m-d',strtotime("+1 month",$regdate));

Increment dates by one month for the rows using partition by in SQL Server

Try this following script.

You can check the DEMO HERE

SELECT A.ID,
A.Name,
A.Type,
DATEADD(MM,(RN-1),A.Date) AS Date
FROM 
(
    SELECT *,
    ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Name,ID) RN
    -- You can also apply the PARTITION on Type
    -- Based on your requirement or data nature.
    FROM your_table
)A

Output is-

ID  Name    Type    Date
1   A       Group1  2000-01-01 00:00:00.000
2   A       Group1  2000-02-01 00:00:00.000
3   c       Group2  2000-01-01 00:00:00.000
4   c       Group2  2000-02-01 00:00:00.000

Incremnet Date By One Month

You can use ->modify to add months to date. This $i is increment variable and add the months to date. ->modify is pretty fast and easy to use.

    $date = new DateTime('now');
    for ($i=1; $i < 9 ; $i++) { 
         $date = new DateTime('now');
         $date->modify("+$i months"); 
         $date = $date->format('Y-m-d');
         echo $date."<br>";
    }

Result:

2020-02-23
2020-03-23
2020-04-23
2020-05-23
2020-06-23
2020-07-23
2020-08-23
2020-09-23

Create list of dates with increment of months and stop increments less than given date in pandas

You could apply pd.date_range on each row to create your required dates and join back to the original DataFrame:

df["start Date"] = pd.to_datetime(df["start Date"], format="%d-%m-%Y")
dates = df.apply(lambda x: pd.Series(pd.date_range(x["start Date"], 
                                                   "2018-12-31", 
                                                   freq=pd.DateOffset(months=12/x["Frequency"]))
                                                   ).add_prefix("Date"), axis=1)
output = df.join(dates.iloc[:,1:])

>>> output
   id start Date  Frequency      Date1      Date2      Date3      Date4
0   1 2015-10-10          1 2016-10-10 2017-10-10 2018-10-10        NaT
1   2 2016-10-20          2 2017-04-20 2017-10-20 2018-04-20 2018-10-20

Google Sheets: Automatically Increment Date by 1 Month

this formula will increase the month every 24th and accounts for year change as well

=IF(DAY(TODAY())>=24,
 DATE(YEAR(TODAY()), MONTH(TODAY())+1, 24),
 DATE(YEAR(TODAY()), MONTH(TODAY()),   24))

---

Related Topics