Manuals/calci/DATEVALUE

DATEVALUE(String)

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 String} represents a date in CALCI format

Description

This function gives the serial number of the given $String$ .
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 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 String} 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 String} , 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 String} is ignored.

The syntax for the function DATEVALUE in ZOS is 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 DATEVALUE(String)} .
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 String} is representing the date in the required format.
For e.g.,DATEVALUE(#1998/01/01..1998/1/15)

Inverse Fisher transformation