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.