Reported for version 9
In order to calculate the difference in hours between given dates, you can use the dateDiff function in the Column Assigner step. Note that you need to set a "correct" last argument to get the difference in hours. For hours, HOUR should be used.
To check the difference in hours, follow the steps below:
- Use your source data with the given dates (timestamps) as an input;
- Add the Column Assigner step to your plan and connect the input to it;
- Double click on the Column Assigner step;
To get the time difference use the following expression:
To get the time difference, which is more than fourteen hours, use the following expression:
Specify the output file.
- Run the plan.
For details, you can refer to the screenshots: