/
DateOffsetByDays function
DateOffsetByDays function
Returns the given date offset by the given number of days. The offset value can be positive, zero, or negative.
Namespace
datetime
Input
base date(date
), day offset(int
)
Output
date(date
)
Example
If basedate
contains 2011-08-18
and daysoffset
contains the value 2
, then the two following functions are equivalent, and return the date 2011–08–20
.
set-column result datetime:DateOffsetByDays('2011-08-18', 2)
set-column result datetime:DateOffsetByDays(basedate, daysoffset)
If basedate
contains 2011-08-18
and daysoffset
contains the value -31
, then the two following functions are equivalent, and return the date 2011–07–18
.
set-column result datetime:DateOffsetByDays('2011-08-18', -31)
set-column result datetime:DateOffsetByDays(basedate, daysoffset)
Related content
DateOffsetByComponents function
DateOffsetByComponents function
More like this
DateFromJulianDay function
DateFromJulianDay function
More like this
DateFromDaysSince function
DateFromDaysSince function
More like this
DaysSinceFromDate function
DaysSinceFromDate function
More like this
YeardayFromDate function
YeardayFromDate function
More like this
MonthDayFromDate function
MonthDayFromDate function
More like this
Created in 2020 by Google Inc.