How can I display and print all the dates within a range

[blamora]

How can I print all the dates within a prescribed period for a repetitive action where forecasted action begins in one year and ends one year later.

 

[synapsevampire]

Pretty vague requirements.

What is the repetitive action?

Are you stating that you want to display every date, but only once for each date based on a column in a table?

Group by the date and place the date in the group header (suppress the details).

If you want to limit the rows being returned, use a parameter field of type date->Range

If this doesn't help, post sample data and expected output.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[blamora]

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 Last_date Actual_Interval Next_date
Item 1 02/04/2003 30 days 03/02/2003
Item 2 02/05/2003 90 days 05/04/2003

Once I set up a beginning date and ending date parameter, I want to see all Next_Dates in the range.

 

[lyanch]

On the condition that you have "last date" and "actual interval" in the database.

You can create forumlas to pull the "interval type" and the number from the "actual interval" field (you will need to look at your data to decide how to do that). Then to display the "next date"

dateadd(*intervalTypecode*, *interval amount code*, {table.lastdate})

Lisa