Webi date difference. Please advise how to achieve the desired results.

Webi date difference. For example:4:00 to 4:20 I need to show the difference between the two times is 20 minutes in the report. expiration Date is of Date type and Curr Day-Final is of String type. Please advise how to achieve the desired results. May 14, 2014 · Hi experts, I have two columns, one is expiration Date and other is Curr Day-Final. I want to subtarct the two dates and want to display the number of Days in another variable. Apr 2, 2015 · Instead you fix this in WEBI,you can easily fix this with the Bex as in Bex we have many date related functions. Also in case you have created formula for date diff in Bex then you can use the same formula in multiple reports. Use DaysBetween for Oct 16, 2008 · Hello friends , I have a requirement to have the number of days between the dates. but when I calculate the formula in WEBI DaysBetween ( [Sale Date]; [Invoice Date]) Dec 14, 2010 · Hi All I want to calculate the difference between two times in report level. . How can i achieve the same? You need to calculate the number of years between two objects in your reporting area: the date you acquired a piece of equipment [Acquired Date], and the date the data was last exported to your reporting area [Last Export Date]. Nov 25, 2024 · Use DatesBetween when you need to analyze time differences in terms of periods like months, quarters, or years, such as comparing sales trends by quarter or year. Aug 4, 2025 · You need to calculate the time elapsed minutes between two objects in your reporting area: the date and time a request for service was received (Received Date], and the date and time the request for service was closed [Closed Date]. irgd xnjd jeyshq acsvb ktctz xputnv bsb ojbxu mhny diyv