Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculate difference between dates - Urgent

Hi,

I have a begin date and end date for a facility which is constant for one week. I have start date which changes during the week.

Eg. Begin Date Start Date End Date

10/07/2007 - 10/07/2007 10/13/2007

10/08/2007

10/09/2007 etc till end of the week.

So records will have constant begin date and end date and changing start dates. I want the difference of the last start date entered with the begin date. I have tried the formula variables where I can get the difference between the begin date and each start date. But this is only possible when I drilldown based on my begin date and start date or else they are 'X'. When I do this drilldown there are bunch of these extra records which I dont want to show. I have to finally use this to divide another key figure.

Is there someway I can get this difference during run time when the user enters start date.

Thanks,

Kal

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question