How do you produce the results of a repeating calculation fields repetitions by its own internal calculation? Is this possible? For example if you wanted Field[1] to be 1 and Field[2] to be 2 and so and so forth via the fields own internal calculation. Why do I want to do this you ask? Because I want to set a repeating calculation field with 7 repetitions with the current weeks dates - repetition 1 being Monday etc. I can isolate the date range of the current week just wanted to know if I could produce a result in a repeating calculation field via its own internal calculation thus eliminating the need to set the repetitions with a script. I have been playing around but just get questions marks.

Get(CalculationRepetitionNumber)

http://fmhelp.filemaker.com/fmphelp_11/en/html/func_ref2.32.18.html#1028830

Thanks, works now. I was using Get( ActiveRepetitionNumber ). Heres an example of what I did.

Dates.fp7.zip

How about something simple?

CurrentWeekR.zip

Nice, thanks Consultant. I was coding to get it done cause I couldn't figure out the reduction quite yet. This helps a lot for further use. Thanks again.

Maybe I can takes this to the point were repetition fields become a problem. Can a specific repetition number be conditionally formatted? Trying to shade current date now.

Can a specific repetition number be conditionally formatted? Trying to shade current date now.

Why would this require conditional formatting of a specific repetition?

Wanted to use conditional formatting to shade, highlight, or change fill color of a single repetition ( the repetition with the current date ). Is there another way to change a fields fill color other than conditional formatting. Formatting calculation functions only act on text right?

Wanted to use conditional formatting to shade, highlight, or change fill color of a single repetition ( the repetition with the current date ).

Yes, I understand that - but the condition is the same for all repetitions (i.e. for the entire repeating field):

Self = Get (CurrentDate)

Got it. Was using Get ( ActiveRepetitionNumber ) in conditional formatting calculation instead of Get ( CalculationRepetitonNumber ) - you'd think I would have learned. Any hoot heres what I have to share from it. This also includes a global that captures data for filtering relationships - events, task and such.

DatesCurrentWeek.fp7.zip

Thanks for the help.

I think you are making this more complicated than it needs to be, by working with text instead of directly with dates. Another by-product of this approach is that the selected date changes when you change the week starting day.

Ok, fixed that. Text fields are used so full date doesn't flash when selected.

DatesCurrentWeek2.fp7.zip

Ok No more edits.