repeating dates

[gephry]

I know I'm doing something wrong. I want a repeating calc field (30 repetitions) to calculate dates 30 days beyond the selected date.

SelectedDate = date field where you select the date

calcDates[30] = repetition1 = SelectedDate + 1, repetition2 = SelectedDate + 2, etc

I originally had 30 fields calculating the previous field + 1 but that was cumbersome! There's got to be an easier way. I've tried a number of things:

Let( [ repetition=Get(ActiveRepetititonNumber); lastrepetition=repetition-1]; If( lastrepetition=0; SelectedDate; SelectedDate + lastrepetition ) )

-----something to that effect; anyhow, it didn't work

The most obvious:

SelectedDate + Get( ActiveRepetitionNumber )

(no good---I realized you must be in a repetition number for it to work)

I just want the 30 repetitions to autofill with the previous repetition + 1.....

hmmm. Ideas?

[comment]

Try:

Extend ( SelectedDate ) + Get(CalculationRepetitionNumber)

[Raybaudi]

Hi

try this:

Extend ( date ) + Get ( CalculationRepetitionNumber )

P.S. obviously result date (not number!)

[Raybaudi]

Hi comment !!

[Fitch]

You could try Extend... oh never mind. :joust:

[gephry]

Extend doesn't work. I mean, it helps the calculation: now the fields contain data. BUT, not the correct data.

They all contain SelectedDate. None of them computed Get( ActiveRepetitonNumber ) ---- because no repetition was selected. Hmmm, maybe it's not possible.

[comment]

Read more carefully?

[Raybaudi]

Hi gephry

two answers with the same calc...do you think we are both wrong ?

Copy and paste that calc... or see what is the difference between CalculationRepetitionNumber and ActiveRepetitonNumber

[gephry]

Ah blimey. My apologies. I hadn't even noticed the CalculationRepetitionNumber instead of ActiveRepetitionNumber.

Extend( SelectedDate ) + Get( CalculationRepetitionNumber ) does exactly what I intended whereas the other does not work at all.

Thanks for all your help!