Table of Contents

, ,

WEEK

Description

Returns the week of the provided date as an integer constant in the range 1-52

Syntax

WEEK (date)

Can be used in the condition of a FIND action.

Parameters

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

Returns

Number: the week of the year for the date, 1-52.

Example

IF WEEK (Account.OpeningDate) = 50 THEN ... 

WEEK_DIFFERENCE, CURRENT_WEEK, YEAR, MONTH