Skip to Content
avatar image
Former Member

Adding workdays to date field

Good afternoon Everyone,

I use BI4 2 Web Intelligence Client

I have searched internet (no just through google) to try and find solution to this, unsuccessfully.

There is plenty of topics on subject of calculating networking days, which are still properly confusing, however, unfortunately I cannot use any of that.

The challenge that I have is following:

I have Release date field that is pulled from Bex Query and I need to add to it another field that contains In House Production time in days (working days) in order to get Estimated Completion Date.

So it would look something like this:

Release Date + In House Production Time = Estimated Completion Date

11/9/2017 + 10 (Working Days) = 11/23/2017

Right now if I use RelativeDate I get ECD of 11/19/2017 (Which is inaccurate)

I tried to apply networking days logic to it, but then depending on IHPT I would have to add the missing amount of days to it, which then again requires to figure out if more weekends show up at the newly created ECD, and so on.

Please help, as use of Webi in my department is hanging on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 14, 2017 at 03:50 PM

    Hi Miroslav,

    Can you share some screeen shots so we will get better idea. Whats your input and expected output.

    If you used the relativedate function it will give you result which you are expected.

    = RelativeDate(CurrentDate();10)

    It will give you 12/24/2017 if current date is 12/14/2017.

    Please let me know details with screenshots.

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded