Table of Contents

, ,

END_OF_WEEK

Description

Returns a date being Sunday of the week that the parameter date represents

Syntax

END_OF_WEEK (date)

Cannot be used in the condition of a FIND action.

Parameters

Attribute of the Date type or date constant or calculation producing Date

Returns

Date: the Sunday of the week containing the given date.

Example

Account.EndOfWeek = END_OF_WEEK(CURRENT_DATE) 

START_OF_WEEK, NEXT_DAY_OF_WEEK, PREV_DAY_OF_WEEK, DAY_OF_WEEK