PreviousMonthEndDate ( myDate )

Shows the end date of the previous month

Average rating: 4.5 (2 votes) Log in to vote

John Gibbs
N/a
http://gibbs-it.tech

Sample input:

PreviousMonthEndDate( 01/03/2018)

Sample output:

28/02/2018

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

Let ( 

[
$date = GetAsDate ( myDate );
$daysToSubtract = Day ( $date );
$endOfLastMonth = GetAsDate ( $date - $daysToSubtract )
];

$endOfLastMonth 
 )

Shows the end date of the previous month

Comments

		Tim Anderson, Tim Anderson Group Mar 7, 2018
You could try date( month ( myDate ) ; 1 ; year ( myDate ) )- 1

		19752, fmc Mar 7, 2018
You use many variable but they all used only once, it can be written as myDate - Day ( myDate ) //date - number is date, then don't need getasdate. And the parameter myDate should be date type, then sample input is wrong. Something like PreviousMonthEndDate( GetAsDate("01/03/2018"))

		Bernard Moreau, Borchtlombeek, Belgium Mar 9, 2018
Tim, even shorter : date( month ( myDate ) ; 0 ; year ( myDate ) )

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

PreviousMonthEndDate ( myDate )

Comments

Support this website.

Support this website.