Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

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)

 

FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.