Time stamp difference in Bex level.

[former_member184624]

Dear BW Experts,

I want to calculate the date differences which is in timestamp format. I just want to perform these calculation in query level instead of writing the Customer exit in the backend.

Please suggest, how to achieve this requirement in Bex level.

Thanks.

[former_member688242]

Please create customer exit and calculate value. I am not sure any method to calculate working days

Please assign if it is helpful

[former_member184624]

Thank you Bansal for your reply.

Along with this calculation, I want to do one more calculation.

That is, i want to find the difference between only on working days. For example Timestamp 2 is Thurday (23rd Dec 2021) and timestamp 1 is Monday (27th Dec 2021). I want to calculate the date and the time excluding the weekends and holidays. Please suggest, do we need to this calculation in Modeling level or Bex Level to achieve this requirement.

Thanks.

[former_member688242]

Try this:

Time((Date2 - Date1)*86400)+(Time1-Time)

86400 eq. 24h * 60 min * 60s

This gives you the Difference in h:mm:ss