The interval for each task is different. Using a dateadd as you suggest wont work. I have to use the actual_interval. I can get the formula to print the last date of the date range parameter. I want to see all the dates within the parameter. This is the formula I am using to get to the last...
I want to return all the dates within a given range. The dates are generated from a formula. I have different intervals for each task. for example, 30 days, 90 days, 365 days, 6 cycles. Each interval is added to the last inspection date to determine the next inspection date.
Item...
From the base date, the next inspection date is calculated in the database. The remaining dates I need are created using a formula adding the date with the inspection interval. As an example:
If the inspection interval is every 30 days my report looks like this
Last_Done Next_Due...
My report takes a base inspection date for a specific item and forcasts upcoming dates between the beginning and ending date parameters. I want to view all the dates within the parameters in the detail section of the report.
I want to display all the due dates within a perscribed period for a repetetive action, where the frequency of the action is every 30 or 90 days and the forcasted start date is one year in the future with an ending date one year later?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.