Brian Dunning's FileMaker Custom Functions

LastDayOfMonth

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
FileMaker Apps
http://filemakerapps.biz

Share on Facebook Share on Twitter

  Sample input:
LastDayOfMonth
  Sample output:
1/31/2006

  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.

 

Comments

Juz   Juz, Virginia
Jul 23, 2011
Thats a very quick and clever method, wish I'd thought of it!
 
Michael Myett   Michael Myett, Boston
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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.