Difference between revisions of "Manuals/calci/MONTH"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
<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")
  

Latest revision as of 13:33, 9 July 2018

MONTH(Value)


  • is the serial number of the month.
    • MONTH(), converts a serial number to a 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

  • 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

  1. =MONTH(32786) = 10
  2. =MONTH(74562) = 2
  3. =MONTH("9/1/1999") = 9
  4. =MONTH("20-may-2004") = 5

Related Videos

MONTH

See Also

References