Skip to Content
Former Member
Apr 01, 2015 at 09:44 PM

Calculate Difference between Two Dates and Eliminate Weekend in WEBI



I have below requirements which i want to find the differences in their time frame.

I do concatenation if Modified Time and Modified Date in to one Column Name (Modified Final)

Again I combine Create Date and Create Time in to column name (Create Final)

Recent Modified Time along with Modified Date.

Modified Time Modified Date Create Date Create Time Final Result 1/1/2010 10:01 1/1/2010 9:30 1/1/2010 1/1/2010 10:01 2/2/2010 12:00 1/1/2010 10:00 2/2/10 12:00 2/1/2010 10:01 2/1/2010 10:00 2/1/2010 10:01

I want to calculate Difference between this

=(Modified Date & Modified Time- Creation Date and Creation Time) and Eliminate Weekends in this range fields.

Final Result Should be

= (Modified Date and Time (days calculate weekdays)- Creation Date and Time(Weekends))