Difference between revisions of "Manuals/calci/DATEVALUE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''DATEVALUE(textdate)'''</div><br/> | <div style="font-size:30px">'''DATEVALUE(textdate)'''</div><br/> | ||
| − | *where textdate represents a date in CALCI format | + | *where <math>textdate</math> represents a date in CALCI format |
==Description== | ==Description== | ||
| − | *This function gives the serial number of the given textdate. | + | *This function gives the serial number of the given <math>textdate</math>. |
*This is used to convert the a date in to a specified serial number. | *This is used to convert the a date in 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(Calci). | ||
| − | *This function will give the result as Error when the textdate is below 1/1/1900. | + | *This function will give the result as Error when the <math>textdate</math> is below 1/1/1900. |
| − | *Also if the year value is not entered in the textdate, this function will consider the current year. | + | *Also if the year value is not entered in the <math>textdate</math>, this function will consider the current year. |
| − | *Time information in textdate is ignored. | + | *Time information in <math>textdate</math> is ignored. |
==Examples== | ==Examples== | ||
Revision as of 07:55, 19 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.
- Also 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(CALCI)
- DATEVALUE("1-APR-1976")=27851
- DATEVALUE("12/12")=37237(CALCI) for the current year 2013.
See Also