MonthReturns a number in the range 1 through 12, representing the number of the month of the year in which date occurs.date - any calendar dateFileMaker Pro 6.0 or earlierMonth(“3/19/2014”) returns 3. This example assumes that the operating system date format is set to MM/DD/YYYY.Month(Payment) returns 3, where Payment contains March 19, 2014. (The Payment field must be of type date.)“Bill Due by: ” & Date(Month(DateSold) + 1;Day(DateSold);Year(DateSold)) returns Bill Due by: followed by a value that is one month later than DateSold.Important To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years.