Date Auto Enter

[gersam]

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, 2010 by Guest

[comment]

Can you explain what purpose will this serve?

[gersam]

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?

[comment]

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.

[gersam]

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