VDA-CreateDateList(name of list a[, name of new list b][, skip amounts c])
Group |
Takes a Named List a consisting of date pairs (from/until) and optional amounts and creates a new list b containing dates according to the VDA specification (e.g. for VDA 4905). If ranges are given, the VDA separator 555555 will be added to the list. The resulting list will start with single dates, followed by the VDA separator 555555 and the ranging dates (if present).
The result of the function is the number of date values in the list. With a list containing amounts, this will be the number of entries divided by 2, otherwise the number of values.
Description of Parameters
Parameter |
Description |
a |
Name of the list containing dates and amounts (if used). |
b |
(optional) Name of the list for the result (or empty if the same list should be used). |
c |
(optional) true if amounts are not in the list. Default: false. |
Examples
Given are the following lists:
DatesWithAmounts with values {2013-10-01, 2013-10-01, 10, 2013-11-01, 2013-11-30, 30, 2013-10-03, , 20}.
OnlyDates with values {2013-10-01, , 2013-10-07, 2013-10-13}.
OnlyFixDates with values {2013-10-01, , 2013-10-07, 2013-10-07}.
Parameter a |
Parameter b |
Parameter c |
Result |
DatesWithAmounts |
NewList |
4 and list NewList with values {131001, 10, 131003, 20, 555555, , 131000, 30}. |
|
DatesWithAmounts |
NewList |
false |
4 and list NewList with values {131001, 10, 131003, 20, 555555, , 131000, 30}. |
DatesWithAmounts |
NewList |
true |
Abortion of function execution because the number of values in the list is not a multiple of 3. |
OnlyDates |
NewList |
false |
Abortion of function execution because the number of values in the list is not a multiple of 2. |
OnlyDates |
NewList |
true |
3 and list NewList with values {131001, 555555, 130041}. |
OnlyFixDates |
NewList |
true |
2 and list NewList with values {131001, 131007}. |