=appendDate(); function
Outline
The =appenddate(); Scripting Engine function is a function that works together with the append mode in data central.
Aliases
=appendDate();
Properties
The parameter function has complex input:
| Property | Datatype | Default value | Description |
|---|---|---|---|
| colref | String | Column |
Name of source system column to filter. You need a primary key on the unique column in the dataset for this to work properly. |
| fromDate | String | = |
|
| toDate | String | = | |
| dateFormat | String | I |
I, U
|
colref property
The setting controls the name of the column which the parameter should reference
"colref": "columnA" => and columnA between '2020-01-01' and '2020-02-01'
fromDate property
The setting controls the fallback when using "Refresh" mode in the provider. Else it will calculate this value according to settings i datatable dialog.
toDate property
The setting controls the fallback when using "Refresh" mode in the provider. Else it will calculate this value according to settings i datatable dialog.
dateFormat property
This parameter specify which dateformat the source datetime column has.
I - ISO Date (YYYY-MM-DD hh:ss:mm)
U - UNIX Date (seconds since 1970-01-01)
"dateFormat": "I" "dateFormat": "U"
Examples:
=appenddate("colref":"saledate","fromDate":"2018-01-01 00:00:00","toDate":"2018-01-31","dateFormat":"I");
