DAY_INTERVAL macro
The DAY_INTERVAL macro
is available only in HCL®
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. |