DAY_INTERVAL macro

The DAY_INTERVAL macro is available only in Unica Campaign.

Syntax

DAY_INTERVAL(from_year, from_month, from_day, to_year, to_month, to_day)

Parameters

from_year

Valid 2-digit or 4-digit year number.

from_month

Valid month number between 1-12.

from_day

Valid day number between 1-31.

to_year

Valid 2-digit or 4-digit year number.

to_month

Valid month number between 1-12.

to_day

Valid day number between 1-31.

Description

DAY_INTERVAL returns the number of days between the specified from date ( from_year/from_month/from_day) and the specified to date (to_year/to_month/to_day).

Examples

DAY_INTERVAL(2000,8,31,2000,12,31) returns the number 122.

Related functions

Function Description
DAY_BETWEEN Returns the number of days between two specified date strings.
DAY_FROMNOW Returns the number of days between the current day and a specified date.