Difference between revisions of "Manuals/calci/DATEVALUE"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
*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 | ||
| Line 19: | Line 24: | ||
*=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]] | ||
Revision as of 01:02, 18 April 2014
DATEVALUE(String)
- represents a date in CALCI format
represents a date in CALCI formatDescription
- 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.
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/1/15)
.
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.