DAY_FROMNOW macro
The
DAY_FROMNOW
macro is available only in
IBM
®
Campaign
.
Syntax
DAY_FROMNOW(to_year, to_month, to_day)
Parameters
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_FROMNOW
returns the number of days between the current day and the date specified by
to_year/to_month/to_day.
If the specified date is in the past, the returned value will be negative.
Examples
If today's date is the 31st of August, 2000,
DAY_FROMNOW(2000,12,31)
returns the number 122.
Related functions
Function
Description
DAY_BETWEEN
Returns the number of days between two specified date strings.
DAY_INTERVAL
Returns the number of days between two specified dates.
Copyright IBM Corporation 2015. All Rights Reserved.