O'Reilly logo

FileMaker 8 Calculation Functions by Bob Bowers, Scott Love, Steve Lane

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MonthName()

Category: Date

Syntax: MonthName ( date )

Parameters:

date—Any valid date (1/1/0001–12/31/4000). The parameter should be a string containing a date (for example, "3/17/2004"), an expression with a date result (for example, Date (6, 29, 1969)), or an integer that represents a serialized date value (for example, 718977).

Data type returned: Text

Description:

Returns the month name of the specified date.

The MonthName() is frequently used for display purposes in subsummary reports. Although you display the name of the month, be sure that you summarize based on the month number (obtained with the Month() function). If you don’t, your report will be summarized alphabetically by month rather than chronologically by month.

Examples:

MonthNameJ() ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required