PreviousMonthName ( myDate )

Returns the name of the month previous to the supplied date. Use case: month-end reports run on the first of the month

Average rating: 2.0 (1 vote) Log in to vote

John Gibbs
N/A
www.gibbs-it.tech

Sample input:

PreviousMonthName (01/03/2018)

Sample output:

February

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

Let ( 

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

MonthName ( $endOfLastMonth )

 )

This is literally only useful for end of month reports that run on the first of the following month - so for example you might want to call the report "End of Month report for February" but it's run on the 1st of Match.

Comments

		Tim Anderson, Tim Anderson Group Mar 7, 2018
or monthName(date( month ( myDate )-1 ; 1 ; year ( myDate ) ) )

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

PreviousMonthName ( myDate )

Comments

Support this website.

Support this website.