ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate the number representing the day of the week for an eight-position date.
With this predefined function, the date set 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 = &DAY_WEEK8(Date format;Date)
Parameters
|
Description |
Contents |
Controls |
Result |
One-position numeric variable. |
Number representing the day of the week corresponding to the date set as a parameter. Possible values: 1 Sunday 2 Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7 Saturday |
|
Date format |
Three-position alphanumeric constant or variable. |
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. |
Date |
Eight-position numeric constant or variable. |
Date for which the number of the week day is to be calculated. |
Mandatory parameter. |
Example
PAYMENT_DATE = 31122000
DAY = &DAY_WEEK8('DMY';PAYMENT_DATE)
*
* DAY is equal to: 5 (Thursday)
IF DAY = 1
* if Sunday, add 1
PAYMENT_DATE = &CALCULATE_DATE8('DMY';PAYMENT_DATE;1)
END
List of predefined functions by topic