Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
<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==
Line 18: Line 18:  
*=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==
writer
6,694

edits

Navigation menu