Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!

AddDays Heater - Calculations on date and time fields

heater-date-time-addThe AddDays Heater allows you to add to and subtract values from date and time values. When the value to add is positive, it is added, but when negative, it is subtracted from the date/time value.

Configuration

Common tab

Calculations on date and time fieldsCalculations on date and time fieldsBy adjusting the settings in the configuration popup for the Heater, you can modify the default specification, which is to calculate days. Alternatives available are: year, month, day, hour, minute and second.
 

Example: You enter the value 5 and configure the Heater for month; this causes the incoming date/time value to have 5 months added to it.

The text input field gives you the possibility of entering a static number or alternatively specify a Parameter (placeholder).

Note: Using Parameters it is possible to define dynamic values that are derived from other import/export fields.

 

 

 

 

Advanced tab

Advanced settingsAdvanced settingsThis tab allows you to configure whether particular days of the week and a list of specific dates are to be ignored in the calculation. For example, this lets you calculate 18 working days after of a given date.

Skip the following days of the week: You check here the days you wish to ignore. Whenever a day of the week is encountered that is checked in this list, the date is advanced (when positive) or reduced (when negative) until the next unchecked day is reached.

List of specific dates to skip: This allows you to attach a text file with an optional list of dates to ignore (e.g. public holidays or vacation periods) that are additionally excluded from the calculation.

 

 

 

 

Please also refer to the general information on the use of Heaters (functions)