FILEMAKER: The Month Function

From Dwayne Wright - www.dwaynewright.com

Month( date )
FMP Version: All recent versions of FileMaker

This function will return the number of the month in a date field or text string formatted in a recognizable date value. This will be a whole number between 1 and 12 because there are only 12 whole months available in a year. This will make it a MOD12 system (if you have read my description of the Mod function, you will know what we mean).

The entered date needs to be within the FileMaker date range of 01/01/01 to 12/31/4000. It also needs to be in format recognizable by FileMaker as an acceptable date value.

January returns a 1
February returns a 2
March returns a 3
April returns a 4
May returns a 5
June returns a 6
July returns a 7
August returns a 8
September returns a 9
October returns a 10
November returns a 11
December returns a 12

EXAMPLE:
Month(5/14/98)
This will return the number 5.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.