writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − + − + Line 18:
Line 18: + + + + +
no edit summary
<div style="font-size:30px">'''DATEVALUE(textdate)'''</div><br/>
<div style="font-size:30px">'''DATEVALUE(String)'''</div><br/>
*where <math>textdate</math> represents a date in CALCI format
*where <math>String</math> represents a date in CALCI format
==Description==
==Description==
*This function gives the serial number of the given <math>textdate</math>.
*This function gives the serial number of the given <math>String</math>.
*This is used to convert the a date in to a specified serial number.
*This is used to convert a date in the form of text to a specified serial number.
*By default , the serial number starts from 1/1/1900.
*By default , the serial number starts from 1/1/1900.
*i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918(Calci).
*i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918.
*This function will give the result as Error, when the <math>textdate</math> is below 1/1/1900.
*This function will give the result as Error, when the <math>String</math> is below 1/1/1900.
*If the year value is not entered in the <math>textdate</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>textdate</math> is ignored.
*Time information in <math>String</math> is ignored.
==Examples==
==Examples==
*=DATEVALUE("1-APR-1976")=27851
*=DATEVALUE("1-APR-1976")=27851
*=DATEVALUE("12/12")=37237 for the current year 2013.
*=DATEVALUE("12/12")=37237 for the current year 2013.
==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/02/15")
==See Also==
==See Also==