Brian Dunning's FileMaker Custom Functions

PayDay ( today ; numweeks )

Check to see if today is Payday.

  Average rating: 4.4 (33 votes) Log in to vote

Casey Dutkus   Casey Dutkus
http://www.accasey.com

Share on Facebook Share on Twitter

  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

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.