WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »

DatePlus
✖
DatePlus

✖
DatePlus[date,n]

gives the date n days after date.

✖
DatePlus[date,{n,step}]

gives the date n calendar steps after date.

✖
DatePlus[date,{{n1,step1},{n2,step2},…}]

gives a date offset by ni steps of each specified size.

✖

gives the date n days after the current date.

✖
DatePlus[offset]

gives the date with the specified offset from the current date.

Details and Options

  • DatePlus shifts dates by any given amount of time, treated either as a physical duration or as a number of calendar steps.
  • DatePlus[date,-n] gives the date n days before date.
  • Dates can be specified in the following forms:
  • DateObject[…]date object
    {y,m,d}year, month, day
    {y,m}the first day of the specified month
    {y}January 1 of the year y
    "string"date as a string ("Jan. 1, 2000")
    {y,m,d,h,m,s}precise time
    timeabsolute time specification
  • Possible step sizes are calendar steps and day types "Year", "Quarter", "Month", "Week", "Day", "Hour", "Minute", "Second", "Weekday", "Weekend", Monday through Sunday, "EndOfMonth", "BeginningOfMonth" and "BusinessDay".
  • Offsets can also be specified using the Quantity framework.
  • {y,m,d} is taken to be equivalent to {y,m,d,0,0,0} etc.
  • DatePlus[date,offset] gives results in the same general format as date.
  • When date is a list, the result has the same length as date, possibly extended to include the smallest step in offset. »
  • When date is a string, the result is in the form specified by $DateStringFormat.
  • DatePlus takes the following options:
  • CalendarType "Gregorian"calendar in which the dates have been specified
    HolidayCalendar Automaticholiday schedule and subspecification for the business day and holiday computations
    Method Automaticdate arithmetic method to use
  • For added time steps with variable duration (e.g. "Month"), date arithmetic can either convert the steps into a physical duration (continuous arithmetic) or treat them all as discrete calendar steps (discrete arithmetic).
  • The option value Method"Continuous" implements continuous arithmetic. Discrete arithmetic is implemented with Methodrolling, where possible rolling methods are "RollForward", "RollBackward" and "RollOver", with the default being "RollBackward".
  • For discrete arithmetic, adding, for example, a month may result in a date that does not exist (e.g. February 30). In such cases, there are three possible options for how that date should be resolved:
  • "RollBackward"roll back to the last existing date (Feb 28)
    "RollForward"roll forward to the next existing date (Mar 1)
    "RollOver"increment from the next existing date (Mar …)

Examples

open allclose all

Basic Examples  (5)Summary of the most common use cases

Add 35 days to January 1, 2017:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-r47qon
Out[1]=1

Use a date string as input:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-b6z1sn
Out[1]=1

Subtract 35 days from a date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-fz3cfm
Out[1]=1

Add 14 weeks to a date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-foa2vf
Out[1]=1

Add 34 days to the current date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-mfx56
Out[1]=1

Scope  (13)Survey of the scope of standard use cases

Date Formats  (5)

DatePlus can take dates in the standard {y,m,d,h,m,s} format of DateList:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-bfpcg1
Out[1]=1

DatePlus can take dates in any format supported by DateString:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-by8qve
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-gqu7c9
Out[2]=2

If a date is given as {y,m,d}, DatePlus returns in the same form:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-chx1uk
Out[1]=1

{y,m} is interpreted as the first day of the specified month:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-e24nac
Out[1]=1

{y} is interpreted as January 1 of the specified year:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-dbd5sn
Out[1]=1

Increments  (8)

Add 10 months to a date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-jjikai
Out[1]=1

Add 40 weeks to a date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-cnot2z
Out[1]=1

Add 7 weeks and 2 days:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-bfamhk
Out[1]=1

Add 1 year to a date list:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-j0wqm8
Out[1]=1

Add 1 month and 15 days to the specified date:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-fb5pc
Out[1]=1

The increment can be specified using the quantity framework:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-ffy1gd
Out[1]=1

Add 2.45 days:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-gbwmz2
Out[1]=1

Subtract 4.6 hours:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-ggkvn
Out[1]=1

Options  (7)Common values & functionality for each option

CalendarType  (2)

Advance a date in the Jewish calendar:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-06ne0
Out[1]=1

Islamic years are shorter than Gregorian years:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-ckki8h
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-i1c8q8
Out[2]=2

HolidayCalendar  (2)

Compare the dates 250 business days away in different countries:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-cknjz8
Out[1]=1

Different markets within a country may have different holiday schedules:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-5idynd
Out[1]=1

Method  (3)

By default, adding a month to May 31 will roll back to June 30:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-sj4lza
Out[1]=1

Using Method"RollForward" will roll forward to the next valid date, July 1:

In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-5nl73b
Out[2]=2

DatePlus[date,"Year"] will move forward 365 or 366 days, depending on the year:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-tey3do
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-fklw7v
Out[2]=2

Quantity[1,"Years"] is equivalent to Quantity[365,"Days"] in the Quantity framework:

In[3]:=3
✖
https://wolfram.com/xid/0cg4y18ci-p1ostv
Out[3]=3

Therefore Method"Continuous" will always add 365 days:

In[4]:=4
✖
https://wolfram.com/xid/0cg4y18ci-tn3okc
Out[4]=4
In[5]:=5
✖
https://wolfram.com/xid/0cg4y18ci-kz9xvv
Out[5]=5

Compare the results of different arithmetic methods when adding a month to January 30, 2021:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-qooahe
Out[1]=1

Compare the results of different rolling methods for January 27 through February 1:

In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-if16kw

Applications  (1)Sample problems that can be solved with this function

Add increasing powers of 10 in seconds starting from the beginning of year 2000:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-i05ttd
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-k3hzh1

Properties & Relations  (2)Properties of the function, and connections to other functions

DatePlus adds calendar steps to dates, while DateDifference computes time distances between dates:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-bgkmgv
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-g7wybo
Out[2]=2

The inverse relationship:

In[3]:=3
✖
https://wolfram.com/xid/0cg4y18ci-is0ti
Out[3]=3
In[4]:=4
✖
https://wolfram.com/xid/0cg4y18ci-ec0owb
Out[4]=4

Use $DateStringFormat to set the default format for date strings:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-koz9h
Out[1]=1

Possible Issues  (3)Common pitfalls and unexpected behavior

Dates can be ambiguous:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-chd2l
Out[1]=1

Use DateList to disambiguate between different interpretations:

In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-d7633i
Out[2]=2

When list increments are specified, they are added from highest order to lowest:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-snrcdk
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-9ehi4c
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0cg4y18ci-27ibu0
Out[3]=3

The order in which calendar units are added can change the results of arithmetic operations, due to variable lengths for months and years:

In[1]:=1
✖
https://wolfram.com/xid/0cg4y18ci-71ooji
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0cg4y18ci-gi6p4i
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0cg4y18ci-hv04a2
Out[3]=3
Wolfram Research (2007), DatePlus, Wolfram Language function, https://reference.wolfram.com/language/ref/DatePlus.html (updated 2023).
✖
Wolfram Research (2007), DatePlus, Wolfram Language function, https://reference.wolfram.com/language/ref/DatePlus.html (updated 2023).

Text

Wolfram Research (2007), DatePlus, Wolfram Language function, https://reference.wolfram.com/language/ref/DatePlus.html (updated 2023).

✖
Wolfram Research (2007), DatePlus, Wolfram Language function, https://reference.wolfram.com/language/ref/DatePlus.html (updated 2023).

CMS

Wolfram Language. 2007. "DatePlus." Wolfram Language & System Documentation Center. Wolfram Research. Last Modified 2023. https://reference.wolfram.com/language/ref/DatePlus.html.

✖
Wolfram Language. 2007. "DatePlus." Wolfram Language & System Documentation Center. Wolfram Research. Last Modified 2023. https://reference.wolfram.com/language/ref/DatePlus.html.

APA

Wolfram Language. (2007). DatePlus. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/DatePlus.html

✖
Wolfram Language. (2007). DatePlus. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/ref/DatePlus.html

BibTeX

@misc{reference.wolfram_2025_dateplus, author="Wolfram Research", title="{DatePlus}", year="2023", howpublished="\url{https://reference.wolfram.com/language/ref/DatePlus.html}", note=[Accessed: 29-March-2025 ]}

✖
@misc{reference.wolfram_2025_dateplus, author="Wolfram Research", title="{DatePlus}", year="2023", howpublished="\url{https://reference.wolfram.com/language/ref/DatePlus.html}", note=[Accessed: 29-March-2025 ]}

BibLaTeX

@online{reference.wolfram_2025_dateplus, organization={Wolfram Research}, title={DatePlus}, year={2023}, url={https://reference.wolfram.com/language/ref/DatePlus.html}, note=[Accessed: 29-March-2025 ]}

✖
@online{reference.wolfram_2025_dateplus, organization={Wolfram Research}, title={DatePlus}, year={2023}, url={https://reference.wolfram.com/language/ref/DatePlus.html}, note=[Accessed: 29-March-2025 ]}