What about holidays and weekends? How are your pay days adjusted? And what is the purpose - is it just to display upcoming dates?
Hi... thanks for answering.
It's just a paid-per-day schedule....no weekend or holiday considerations needed.
Then you can provide a global date field (even use a field from your Preference table) to hold the starting payroll date. Determine whether field should be global (each User enters their own starting value) or use date field in related Preferences table. Global fields can be accessed from any table (even without a relationship). Calculation field (result is date) set to 14 repetitions would be:
i = Get ( CalculationRepetitionNumber ) ;
Extend ( globaldateField )+ i * 14
This calculation concept using repetition number to extend dates or numbers was first shown to me by Comment (Michael Horak). It is a great Developer tool for calendaring and extending date spans as well.
That works perfectly!! Thanks so much!! :)