Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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 - Show more from this author FileMaker Apps

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

Let ( [ M = Month ( Get ( CurrentDate ) ) + 1; Y = Year ( Get ( CurrentDate ) ); D = 1 ] ; Date ( M ; D ; Y ) - 1 ) Click to copy

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, Virginia Jul 23, 2011
Thats a very quick and clever method, wish I'd thought of it!

		Michael Myett, FileMaker Apps Jul 23, 2011
Thanks. That's rare, usually I windup doing it the hard way.

		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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 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: