writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + + − + − + − +
no edit summary
<div style="font-size:30px">'''MONTH(value)'''</div><br/>
<div style="font-size:30px">'''MONTH(Value)'''</div><br/>
*<math>value</math> is the serial number of the month.
*<math>Value</math> is the serial number of the month.
**MONTH(), converts a serial number to a month.
==Description==
==Description==
*This function gives the month of a given date represented by a serial number.
*This function gives the month of a given date represented by a serial number.
*In <math>MONTH(value)</math>, <math>sl.no</math> is the serial number of the month or we can give the date value in[[Manuals/calci/DATE | DATE ]] function format.
*In <math>MONTH(Value)</math>, <math>Value</math> is the serial number of the month or we can give the date value in[[Manuals/calci/DATE | DATE ]] function format.
*MONTH("2/1/1997") for 2nd month.
*MONTH("2/1/1997") for 2nd month.
*The result of the function is an integer 1 to 12(January to December).
*The result of the function is an integer 1 to 12(January to December).
==ZOS==
==ZOS==
*The syntax is to find the month of the given serial number in ZOS is <math>MONTH(value)</math>.
*The syntax is to find the month of the given serial number in ZOS is <math>MONTH(Value)</math>.
**<math>value</math> is the serial number of the month.
**<math>Value</math> is the serial number of the month.
*For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014")
*For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014")