i have 2 datetime fields in webi (SAP BO 4.2). How to subtract 2 datetime fields they are in below format
1/2/2021 5:34:04 AM - 1/2/2021 5:28:38 AM
output should be like 00:00:00 (HH:MM:SS)
Lookup the function: TimeBetween()
The you can create variables and format to anything you may need
5 Likes
Thx you for answer! It worked!
Yes that function is there, but wanted the 00:00:00 format. This guy gave the full solution
Thanks for your input as well!
https://answers.sap.com/questions/13305256/convert-solid-number-to-000000-format.html
thank you for the solution… tried and tested. HNY