VDA-CreateDateList(name of list a[, name of new list b][, skip amounts c])


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}.