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

Share on Facebook Share on Twitter

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

  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.



Tim Anderson   Tim Anderson, Tim Anderson Group
Mar 7, 2018

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

Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: