Calculate difference between dates - Urgent
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/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.