This content has been marked as final. Show 2 replies
Please try this: subtract-dayTimeDuration-from-dateTime(ColumnName1,ColumnName2)
Provided the ColumnName1 and ColumnName2 should be of the same DataType format.
(EndDate-StartDate)/86400 -- will give u days , but am now sure how to get hh:mm:ss after that
Hope this will help.
If you have found solution please update.