Skip to Content
0
Former Member
Mar 02, 2009 at 02:23 PM

Reg : Difference between Dates

30 Views

Hi Friends,

I am having an issue in finding out the date differences .

I am working on a report that shows the planned hours for a production order based on activities and work center. it is having a start date and end date as characteristics.

User will input the a date range and if the start and end date are lying in the given range it should give the sum of hours for all the production orders at a work center level. This comes straight forward.

But if the start date lies in the given user range and end date in future. The caluclation of the Planned hours is difference between the ( User given date (to value ) - start date ) * 24 * 60 Mins. , as user enters from and to value.

I have tried with characteristic value replaced by key and using a formula to get the difference , this works only when the start date is in rows or columns.

The report requires at a much summarized level, So I cannot use it .

I then tried making the start date a Keyfigure and then created a formula , but this is also not working .

Kindly give me some idea or solution if anyone has worked.

Thanks,

Krish

Edited by: VSK on Mar 3, 2009 3:09 AM