Difference between revisions of "Manuals/calci/DATEVALUE"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
==Examples== | ==Examples== | ||
| − | *DATEVALUE("3/20/2005")=38431 | + | *=DATEVALUE("3/20/2005")=38431 |
| − | *DATEVALUE("6/7/1960")=58599 | + | *=DATEVALUE("6/7/1960")=58599 |
| − | *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. |
==See Also== | ==See Also== | ||
Revision as of 01:36, 20 November 2013
DATEVALUE(textdate)
- where 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 the a date in 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(Calci).
- 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.