E
efandango
I want to work out the expected Finish date of a project based on taking
todays date and subracting it against a finite number of days for the project
(290), using the current record's Run No as the subracting factor.
So for example:
[TodaysDate]: 29/03/2009
[Run_No]: 61
ProjectTotalDays: 290
number of days to complete =229
[DatetoComplete]: ?
How would I go about doing this?
todays date and subracting it against a finite number of days for the project
(290), using the current record's Run No as the subracting factor.
So for example:
[TodaysDate]: 29/03/2009
[Run_No]: 61
ProjectTotalDays: 290
number of days to complete =229
[DatetoComplete]: ?
How would I go about doing this?