Table of Contents

, , ,

NEXT_DAY_OF_WEEK

Description

Returns the next day of the week closest to the specified date

Syntax

NEXT_DAY_OF_WEEK (date, day)

Cannot be used in the condition of a FIND action.

Parameters

An expression producing a date and a string identifying the day

Returns

Date: the next date after the given date that falls on the named weekday.

Example

Object.NextDay = NEXT_DAY_OF_WEEK (CURRENT_DATE, 'Tuesday')  
/** This returns next Tuesday from current date**/ 

PREV_DAY_OF_WEEK, DAY_OF_WEEK, START_OF_WEEK, END_OF_WEEK