To the given date and the week day, get the next date after input date that corresponds to the week day.
Syntax
GetNextDay ( date, week_day, [0|1] )
Parameter | Description |
---|---|
date | A number representing the input date between January 1, 1970 and Dec 31, 2037. The number is the number of seconds elapsed since midnight, January 1, 1970. To retrieve this number, use any of the following functions: Today(), TodateEx(), GetFirstDate(), GetLastDate(), DateRoll(). Date-Time type attribute properties of a member can also be used to retrieve this number. For example: Product.currentmember.[Intro Date] returns the Introduction or release date for the current product in context. [Cola].[Intro Date] returns the Introduction or release date for the “Cola” product. |
week_day | A number between 1 (Sunday) and 7 (Saturday) representing the week day. |
0 or 1 | Optional. Indicates whether to include the date itself or not. Default behavior is 1: to include the date itself. |
Example
GetNextDay(Today(), 2, 0)
returns the next Monday following today.
GetNextDay(Today(), 2, 1)
returns the next Monday following today, or today if today is Monday.
GetNextDay(Today(), 2)
returns the next Monday following today, or today if today is Monday.
See Also