Brian Dunning's FileMaker Custom Functions


Returns the last day of the current month. Does not require any parameters.

  Average rating: 3.9 (43 votes) Log in to vote

Michael Myett   Michael Myett - Show more from this author
FileMaker Apps

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Returns the date of the last day of the current month. The calculation needs to be unstored and will automaticly update based on the current date.

You can add one parameter, theDate, and replace Get ( Current Date ) in the function definition with it, and store the calculation, for different uses.



Juz   Juz, Virginia
Jul 23, 2011
Thats a very quick and clever method, wish I'd thought of it!
Michael Myett   Michael Myett, FileMaker Apps
Jul 23, 2011
Thanks. That's rare, usually I windup doing it the hard way.
Brian Donovan   Brian Donovan, Mexico
Feb 21, 2015
Month =12 + 1 = 13

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: