Brian Dunning's FileMaker Custom Functions

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   John Gibbs
N/A
www.gibbs-it.tech

Share on Facebook Share on Twitter

  Sample input:
PreviousMonthName (01/03/2018)
  Sample output:
February

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

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, Tim Anderson Group
Mar 7, 2018
or


monthName(date( month ( myDate )-1 ; 1 ; year ( myDate ) ) )
 

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.