Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
  • Home
  • Documentation
  • DaysDiff Heater - Calculating the difference between date and time values

DaysDiff Heater - Calculating the difference between date and time values

heater-date-time-diffThe DaysDiff Heater makes it possible to calculate the difference between two date and/or time fields. You must always supply  two incoming date/time values to the Heater. The second incoming value is subtracted from the first.

Configuration

Calculating date and time valuesCalculating date and time valuesIn the configuration popup for the Heater you can define the units you want the result in. The following options are available:

  1. Days (default)
  2. Hours
  3. Minutes
  4. Seconds

You can also check another configuration option if you want decimal fractions to be returned, for example, from the date/time values

1st incoming value: 02/06/2012 12:00:00
2nd incoming value: 02/06/2012 00:00:00

a difference of 0.5 (half a day) is returned. In this instance, without a decimal fraction a zero value would result.

 

Advanced tab

Calculating date and time valuesCalculating date and time valuesThis tab only becomes active when the option “Difference in days” is selected under the Common tab

Only the following days shall count: This allows you to specify which days of the week qualify in the calculation of a difference in days. This is useful, for example, when only working days are to be taken into account. By default all days are taken into account for the calculation of differences.

List of specific dates to ignore: To additionally exclude possible public holidays from the calculation, you can optionally select here a text file containing a list of dates. Each date must occupy a separate line in the list. The path to the text file can be either absolute or relative. Note: Relative paths are always relative to the folder containing the FlowHeater Definition file.

Important: The date format used for the list of dates must correspond with the Adapter format specification, further information about this is available here: General information about usage of Adapters

 

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