creating a date line

[Aussie John]

Hi I wanted to create a series of dates starting at a particular date then continuing at weekly intervals after.

I thought I could use a repeating field. Is it possible to define each field as a calculation based on the previous field (ie previous field plus 7). Maybe there is a better way, but it needs to be dynamic and changes depending on the initial date.

This is the first step in making a project task based timeline database. I'm hoping i can use the same theory for the actual task duration and display.

Thanks for any help!!

[Aussie John]

actually found my solution

use a calculation

"Get ( currentDate )+(Get ( CalculationRepetitionNumber )*7)"

Edited December 24, 2005 by Guest

[Aussie John]

actually now a problem if I substitute a field date instaed of the current date it no longer works

datestart+(Get ( CalculationRepetitionNumber )*7)

the first field is ok but the next dates go back to the year 0001

[LaRetta]

You need to include Extend(). Result is date.

Try:

Extend ( datestart) + (Get ( CalculationRepetitionNumber )*7)

It would have worked with Get(CurrentDate) because it isn't tied to the current record. Referencing a date field would be.

[Aussie John]

thanks La Retta that got it going