Table of Contents

, ,

DAY_NUMBER_IN_WEEK

Description

Returns day of week of the provided date (1 for Sunday, 2 for Monday etc)

Syntax

DAY_NUMBER_IN_WEEK (date)

Parameters

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

Returns

Number: the day of the week of the date (1 for Sunday, 2 for Monday, etc.)

Example

IF DAY_NUMBER_IN_WEEK (Account.OpeningDate) = 1 THEN ... 

DAY_OF_WEEK, CURRENT_DAY_OF_WEEK, NEXT_DAY_OF_WEEK