Table of Contents

, ,

DAY_DIFFERENCE

Description

Calculates the day difference between the two dates as an integer constant

Syntax

DAY_DIFFERENCE (date1, date2)

Can be used in the condition of a FIND action.

Parameters

Two attributes of the Date type or date constants or calculations producing date

Returns

Number: the number of days between the two dates, always positive (the order of the dates does not matter)

Example

IF DAY_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 3 THEN ... 

DAY_DIFFERENCE2, DATE_ADD, WEEK_DIFFERENCE, MONTH_DIFFERENCE