Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Date functions > Month function |
|
|
| Month function |
| Format |
Month(date) |
| Parameter |
| date - any calendar date |
| Data type returned |
| number |
| Description |
| Returns a number in the range 1 through 12, representing the number of the month of the year in which date occurs. |
| 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. |
| Examples |
| Month("3/19/2008") 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, 2008. (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. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Date functions > Month function |
|
|
Next Page |
|