ADELIA |
VADELIA |
SADELIA |
WADELIA |
EADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(B) |
Description
This predefined function is used to calculate the interval (number of days) between two eight-position dates.
With this predefined function, the dates set as parameters are checked. If one of them is not valid, the function is not run and the result field is reset to zero.
Syntax
Result = &DATES8_INTERVAL(Date format;Beginning date;End date)
Parameters
Description |
Contents |
Controls |
|
Result |
Seven-position numeric variable. |
Number of days calculated between the two dates set as parameters. |
|
Date format |
Three-position alphanumeric constant or variable. |
Format for the dates set as a parameters. Possible values: DMY Day/Month/Year DYM Day/Year/Month MDY Month/Day/Year MYD Month/Year/Day YMD Year/Month/Day YDM Year/Day/Month |
Mandatory parameter. |
Beginning date |
Eight-position numeric constant or variable. |
Calculation beginning date. |
Mandatory parameter. |
End date |
Eight-position numeric constant or variable. |
Calculation end date. |
Mandatory parameter. |
Note: The beginning date must be earlier than the end date, otherwise the obtained result is negative.
Example
FORMAT = 'MDY'
ORDER_DATE = 12312000
PAYMENT_DATE = 01202001
NB_DAYS_DIFF = &DATES8_INTERVAL(FORMAT;ORDER_DATE;PAYMENT_DATE)
*
* NB_DAYS_DIFF is equal to: 20
NB_DAYS_DIFF = &DATES8_INTERVAL(FORMAT;PAYMENT_DATE;ORDER_DATE)
*
* NB_DAYS_DIFF is equal to: -20
List of predefined functions by topic