PayDay ( today ; numweeks )
Check to see if today is Payday.
Average rating: 4.4 (33 votes) Log in to vote
Casey Dutkus - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Today is the date you'd like to check. Frequency is based on weeks (How often a paycheck is issued).
If you get paid on a day other than "Friday", edit the function.
I actually use this as a Boolean for custom formatting on a calendar. If it's "Pay Day" or 1 then I change the fill to green.
Case(Mod(WeekOfYear ( today );numweeks) = 0 and DayName( today ) = "Friday"; 1; 0)
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.