Hi All,

Small Problem...Defined a field called "CurrentMonth" and a field called "Day" which is a repeating field of 31 days depending on the current month. If CurrentMonth = January 2010 then I want to have Filemaker auto-enter the numbers 1-2-3...31, etc. into the repeating field of "Day". Any ideas?

Edited January 1, 201016 yr by Guest

Can you explain what purpose will this serve?

Hi Conultant,

I'm trying to make an attendance timesheet as part of a largr Payroll module. I'm using repeating fields because I dont want to create 31 fields for January for every month. I also dont want to have to repeat the exercise in 2011 and thereafter. Can you help?

I would suggest you create a separate record for each entry, instead of each month.

In any case, you could create such labels using a repeating calculation field =

Let ( [

i = Get ( CalculationRepetitionNumber ) ;

end = Day ( Date ( Month ( Extend ( Datefield ) ) + 1 ; 0 ; Year ( Extend ( Datefield ) ) ) )

] ;

Case ( i ≤ end ; i )

)

where Datefield contains any date in the specified month.

Thanks Conultant...that was helpful not only for the current issue, but also for another similar issue I was facing. You're a genius...