Function:  

SECONDS  

Description:  

Returns an integer constant indicating the number of seconds in the provided duration  

Parameters:  

Attribute of the Duration type or duration constant or calculation producing duration  

Example:  

If  SECONDS (Task.Duration) =  5 Then …

   

Function:  

START_OF_WEEK  

Description:  

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

Parameters:  

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

Example:  

Account.StartOfWeek = START_OF_WEEK(CURRENT_DATE)

   

Function:  

TIME_ADD  

Description:  

Returns the timestamp resulting from adding/subtracting the specified number of hours to the specified timestamp  

Parameters:  

An expression producing timestamp and an expression producing a number to be added or subtracted (if the number is negative) to the timestamp  

Example:  

If  TIME_ADD (Account.OpeningTime), 4) = 07/04/2004 12:00 Then …

   

Function:  

TIMESTAMP  

Description:  

Returns the timestamp constant built from the given numbers  

Parameters:  

An integer constant indicating day (1-31), an integer constant indicating month (1-12), an integer constant indicating year, an integer constant indicating hours (0-23), an integer constant indicating minutes (0-59)  

Example:  

If  TIMESTAMP (DAY_OF_MONTH (Account.OpeningDate), 4, 2004, 11, 0) = 07/04/2004 11:00 Then …

   

Function:  

WEEK  

Description:  

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

Parameters:  

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