FileMaker Pro Custom Functions

/* ================================================== 05/30/2004 1.0 KLN Original Version Gives the Nth Occurance from a given date. Returns "" If Improper weekday is entered or less than 1 reptation (i.e. only calculates forward to a date in the future) Format for WeekDay is the same as returned by FM with the DayName() function or can be a standard three letter day format. A date is returned. TheDate = Date to calculate from Weekday = Name of day to find Reps = Number of day cycles in the future to find ================================================== */ Let (DayToGet = Case( Weekday = "Sunday" or Weekday = "Sun"; 1; Weekday = "Monday" or Weekday = "Mon"; 2; Weekday = "Tuesday" or Weekday = "Tue"; 3; Weekday = "Wednesday" or Weekday = "Wed"; 4; Weekday = "Thursday" or Weekday = "Thr"; 5; Weekday = "Friday" or Weekday = "Fri"; 6; Weekday = "Saturday" or Weekday = "Sat";7;0); If ( DayToGet=0 or Reps < 1 ; "" ; If (DayToGet = DayOfWeek ( TheDate ); TheDate + (Reps *7); If ( DayOfWeek ( TheDate ) < DayToGet; TheDate + (DayToGet -DayOfWeek( TheDate)) + ((Reps-1) * 7) + 1; TheDate - (DayOfWeek ( TheDate ) - DayOfWeek ( DayToGet ))+ (Reps) * 7) - 1 )))
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.