Month
Returns a number from 1 to 12, representing the month of the year in which a date occurs.
Format
Month ( date )
Parameters
date - any calendar date
Data type returned
number
Originated in version
6.0 or earlier
Example 1
Month ( "3/19/2019" ) returns 3. This example assumes that the operating system date format is set to MM/DD/YYYY.
Example 2
Month ( Payment ) returns 3, where Payment contains March 19, 2019. (The Payment field must be of type date.)
Example 3
Returns Bill Due by: followed by a value that is one month later than DateSold.
Copy
"Bill Due by: " &
Date (
Month ( DateSold ) + 1 ;
Day ( DateSold ) ;
Year ( DateSold )
)