Manuals/calci/DATEVALUE

From ZCubes Wiki
Revision as of 04:22, 14 April 2014 by Devika (talk | contribs)
Jump to navigation Jump to search
DATEVALUE(String)


  • where represents a date in CALCI format

Description

  • This function gives the serial number of the given .
  • 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.
  • 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 is below 1/1/1900.
  • If the year value is not entered in the , this function will consider the current year.
  • Time information in is ignored.

Examples

  • =DATEVALUE("3/20/2005")=38431
  • =DATEVALUE("6/7/1960")=58599
  • =DATEVALUE("1-APR-1976")=27851
  • =DATEVALUE("12/12")=37237 for the current year 2013.

ZOS Section

  • The syntax for the function DATEVALUE in ZOS is .
  • is representing the date in the required format.
  • For e.g.,DATEVALUE("1998/01/01".."1998/02/15")

See Also

References

Complex Numbers