writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 11:
Line 11: + + + + + + − Line 19:
Line 24: − ==ZOS Section== − *The syntax for the function DATEVALUE in ZOS is <math>DATEVALUE(String)</math>. − *<math>String</math> is representing the date in the required format. − *For e.g.,DATEVALUE(#1998/01/01..1998/1/15) −
no edit summary
*If the year value is not entered in the <math>String</math>, this function will consider the current year.
*If the year value is not entered in the <math>String</math>, this function will consider the current year.
*Time information in <math>String</math> is ignored.
*Time information in <math>String</math> is ignored.
==ZOS Section==
*The syntax for the function DATEVALUE in ZOS is <math>DATEVALUE(String)</math>.
*<math>String</math> is representing the date in the required format.
*For e.g.,DATEVALUE(#1998/01/01..1998/1/15)
==Examples==
==Examples==
*=DATEVALUE("3/20/2005")=38431
*=DATEVALUE("3/20/2005")=38431
*=DATEVALUE("6/7/1960")=58599
*=DATEVALUE("6/7/1960")=58599
*=DATEVALUE("12/12")=37237 for the current year 2013.
*=DATEVALUE("12/12")=37237 for the current year 2013.
==See Also==
==See Also==
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/DAY | DAY]]
*[[Manuals/calci/DAY | DAY]]