DateFromDaysSince function
Returns a date object by adding an integer to a baseline date. The integer can be negative to return a date that is earlier than the baseline date.
Namespace
datetime
Input
number (long
), [baseline date(date
)]
Output
date (date
)
Example
If offset
contains the integer 18250, and basedate
contains the date 1958–08–18
, then the three following functions are equivalent, and return the date 2008–08–05
set-column result datetime:DateFromDaysSince(18250, '1958-08-18')
set-column result datetime:DateFromDaysSince(offset, basedate)
If a
contains the integer -1, and b
contains the date 1958–08–18
, then the following three functions are equivalent, and return the date 1958–08–17
:
set-column result datetime:DateFromDaysSince(-1, '1958-08-18')
set-column result datetime:DateFromDaysSince(offset, basedate)
Created in 2020 by Google Inc.