/
DateFromDaysSince function
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)
Related content
DaysSinceFromDate function
DaysSinceFromDate function
More like this
CurrentDate function
CurrentDate function
Read with this
Google Ads Multiple Report Batch Source (Deprecated)
Google Ads Multiple Report Batch Source (Deprecated)
More like this
Google Ads Single Report Batch Source (Deprecated)
Google Ads Single Report Batch Source (Deprecated)
More like this
ORC Dynamic Partitioned Dataset Sink (Deprecated)
ORC Dynamic Partitioned Dataset Sink (Deprecated)
More like this
Salesforce Marketing Cloud Batch Source
Salesforce Marketing Cloud Batch Source
More like this
Created in 2020 by Google Inc.