Manuals/calci/DATEVALUE

DATEVALUE(textdate)

• where $textdate$ represents a date in CALCI format

Description

• This function gives the serial number of the given Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle textdate} .
• 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle textdate} is below 1/1/1900.
• If the year value is not entered in the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle textdate} , this function will consider the current year.
• Time information in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle textdate} 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

• DATE
• DAY

References

Complex Numbers