Skip to Content
author's profile photo Former Member
Former Member

Add 3 Working Days to Date Field

hi,

I have requirement to add 3 working days to Received Date(info object) in BEx.

i can easily add just 3 days. but can anyone let me know how to add 3working days in Bex.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 18, 2014 at 11:35 AM

    Hi,

    we can, please explain more on issue?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2014 at 12:57 PM

    Hi Lavanya,

    First of all in your system, Factory calender must be configure.
    If so then you can try CMOD logic for this.logic for the same is below:

    Add number of days to your "Received Date". and check wether output is working day or not via FM "CHECK_IF_WORKING_DAY".
    if it is not working day then add 1 until FM "CHECK_IF_WORKING_DAY" returns output as working day.

    Thanks,
    Renish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Let me explain my requirement again.

      I have requirement to populate First contact due date = Received + 3 days

      And these three days should be 3 working days.

      For example:

      Received date is 18th July (Friday), then while adding 3 days, I need to exclude Saturday and sunday so that First contact due date is populated as 23rd July.

      I hope it is clear now. We have factory calendar defined in BW system. and i want this to be derived in BEx only.

      Any suggestions?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.