Manuals/calci/MONTH - Revision history

Devika at 19:33, 9 July 2018

2018-07-09T19:33:26Z

2017-03-13T12:21:17Z

2015-06-20T01:22:22Z

2015-06-03T16:57:49Z

ZOS Section

2015-05-12T18:09:00Z

References

2014-07-04T05:49:51Z

2014-01-03T09:04:07Z

Examples

2014-01-03T09:03:23Z

Description

2014-01-03T08:54:36Z

Description

2014-01-01T07:51:54Z

@@ 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.
 ==Description==
 *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.
 *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 <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")

← Older revision		Revision as of 12:21, 13 March 2017
Line 30:		Line 30:
	==References==		==References==
	*[https://exceljet.net/excel-functions/excel-month-function Month]		*[https://exceljet.net/excel-functions/excel-month-function Month]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 18: / Line 18: @@
 #=MONTH("9/1/1999") = 9
 #=MONTH("20-may-2004") = 5
 ==See Also==

@@ Line 8: / Line 8: @@
 *The result of the function is an integer 1 to 12(January to December).
-==ZOS Section==
+==ZOS==
 *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.

← Older revision		Revision as of 18:09, 12 May 2015
Line 25:		Line 25:

	==References==		==References==
		+	*[https://exceljet.net/excel-functions/excel-month-function Month]

@@ Line 9: / Line 9: @@
 ==Examples==
-#MONTH(32786)=10
+#=MONTH(32786) = 10
-#MONTH(74562)=2
+#=MONTH(74562) = 2
-#MONTH("9/1/1999")=9
+#=MONTH("9/1/1999") = 9
-#MONTH("20-may-2004")=5
+#=MONTH("20-may-2004") = 5
 ==See Also==