With this function, you can do two kinds of data calculations:
- Calculate the number of hours, days, or other time unit between two different input dates. In this case, input fields are dates of the same date format.
- Calculate a new date by adding a given number of hours, days, or other time unit to a given date. In this case, the first input is the start date. The second input is a positive or negative number of units (e.g. days, hours) to be added to the date. The result is the new date in the same format as the start date.
In both cases, two input fields (StartDate and EndDate) are required
|Defines the date format of the source data, such as
|Defines the time unit for the date calculation. Possible values include seconds, minutes, hours, days, weeks, months, and years.|
Defines the time zone for date functions, taking daylight saving into consideration. For example, you can calculate the difference between two dates in locations with and without daylight saving (i.e., Eastern Savings Time and India Time) and the result will factor the difference in the number of days.
If no time zone is specified, then the system time zone is used.
|Sets the input and output language. Any Jedox-supported language can be selected.|
|15.10.2012 08:00||15.10.2012 17:00||minutes||540|
The last two samples can be used for the conversion of a date to a timestamp in Excel.