cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate working days based on two dates

Former Member
0 Kudos
64

Hi,

Could you please help me in calculating working days based on Actual delivery date and Actual GI date.

Thanks in advance,

Pankaj

Accepted Solutions (0)

Answers (3)

Answers (3)

esjewett
Active Contributor
0 Kudos

Please make sure to search before asking questions on SCN. This is required by the rules. It really helps if, in your question, you mention where you have already looked and the documents you have already read. This will help us moderators see that  you are following the rules, and it will help you because you won't get answers telling you to look at things you have already seen.

This thread will now be locked.

Regards,

Ethan

(moderator)

Former Member
0 Kudos

Hi

Check this code in the link.

http://wiki.sdn.sap.com/wiki/display/Snippets/calculate+no+of+working+days+between+two+dates

It is written for ECC but should be helpful in writing your code for BI.

Regards

Murthy

Former Member
0 Kudos

Hi,

You have to write a customer exit in CMOD for it.

Use FM DATE_CONVERT_TO_FACTORYDATE to convert date into factory date calender. The working day calender should be maintain at BI Side. You can check that in SCAL Transaction. Convert both the date through this FM and take the difference and return it back through CMOD.