The addDays() function provides the ability to add or subtract days from a date. Syntax addDays(date, integer) Argument Description date (required) An...

The betweenDates() function returns the specified values between two dates into a time-series array. Syntax betweenDates(value, startDate, endDate) Argument Description value (required)...

The day() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the...

The days() function returns the number of days between two dates. Syntax days(date1, date2) Argument Description date1 (required) An expression that results...

The addMonths() function provides the ability to add or subtract months from a date. Syntax addMonths(date, integer) Argument Description date...

The workDays() function returns the number of weekdays (i.e., Monday through Friday) between two dates. Syntax workDays(date1, date2, [holidays]) Argument...

The addWorkDays() function provides the ability to add or subtract weekdays (i.e., Monday through Friday) from a date. Syntax addWorkDays(date,...