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
http://www.accasey.com |
Sample input:
PayDay ( 01/01/01; 2 )
Sample output:
"Pay Day!"
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.
Alternative:
Case(Mod(WeekOfYear ( today );numweeks) = 0 and DayName( today ) = "Friday"; 1; 0)
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.