on 05-20-2016 9:12 AM
Hi Webi Gurus,
I have to create a new Webi Report and there i need to calculate a new Date based on Value Date (ValueDate+4 Workdays)
eg.
Value Date New Date
20.05.2016 + 4 Workday = 26.05.2016
Can you help me ?
Thanks
Nas
use this.
=If(DayName([Value Date])="Monday") Then RelativeDate([Value Date];4) Else RelativeDate([Value Date];6)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
People have resorted to do the holiday part in data itself :-
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.