writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − +
Manuals/calci/DATEVALUE (view source)
Revision as of 12:55, 19 November 2013
, 12:55, 19 November 2013no edit summary
<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==