&CALCULATE_DATE8

ADELIA	VADELIA	SADELIA	WADELIA	EADELIA
(I/B)	(I/B)	(B)	(I/B)	(B)

Description

This predefined function is used to calculate an eight-position date by adding a number of days to a beginning date.

With this predefined function, the date given as a parameter is checked. If it is not valid, the function is not run and the result field is reset to zero.

Syntax

Result = &CALCULATE_DATE8(Date format;Beginning date;Number of days)

Parameters

	Description	Contents	Controls
Result	Eight-position numeric variable.	Date calculated.
Date format	Three-position alphanumeric variable or constant.	Format for the date set as a parameter 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 variable or constant.	Beginning date to which the number of days set as a parameter is added.	Mandatory parameter.
Number of days	Seven-position numeric variable or constant.	Number of days to be added to the beginning date.	Mandatory parameter.

Note: If this parameter Number of days is negative, the number of days specified is deducted from the beginning date.

Example

ORDER_DATE = 20001231

NUMBER = 20

DEADLINE = &CALCULATE_DATE8('YMD';ORDER_DATE;NUMBER)

*

* The deadline date is 20010120

*

FORMAT = 'DMY'

END_CONTRACT = 06012001

NUMBER = -366

*

ORIGIN_DATE = &CALCULATE_DATE8(FORMAT;END_CONTRACT;NUMBER)

*

* The origin date is 06012000

List of predefined functions by topic

↑ Top of page