NEXTNDAY

Filters a range of data for 'n' days after the current date.

The NEXTNDAY function can be used to select data from a given measure for a specified number of days after the current day. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.

Syntax

NEXTNDAY(number_of_days)

Arguments

number_of_days – The number of days for which data has to be fetched. Required.

Return value

Period Range.

Example

NEXTNDAY(45) 
//Returns data for 45 days after the current day

NEXTNDAY