Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''MONTH( | + | <div style="font-size:30px">'''MONTH(value)'''</div><br/> |
− | *<math> | + | *<math>value</math> is the serial number of the 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( | + | *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. |
*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 Section== | ||
+ | *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. | ||
+ | *For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014") | ||
==Examples== | ==Examples== |
Revision as of 23:49, 3 July 2014
MONTH(value)
- is the serial number of the month.
Description
- This function gives the month of a given date represented by a serial number.
- In , is the serial number of the month or we can give the date value in DATE function format.
- MONTH("2/1/1997") for 2nd month.
- The result of the function is an integer 1 to 12(January to December).
ZOS Section
- The syntax is to find the month of the given serial number in ZOS is .
- is the serial number of the month.
- For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014")
Examples
- =MONTH(32786) = 10
- =MONTH(74562) = 2
- =MONTH("9/1/1999") = 9
- =MONTH("20-may-2004") = 5