Manuals/calci/DATESTRING

DATESTRING (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 any date value.

Description

This function takes a date string and returns the date with month and day name.
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 DATESTRING(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 the any date value.
This function is useful for setting date values based on string values.
For Example,DATESTRING("2/2/1982") returns Tue Feb 02 1982 00:00:00 GMT+0530 (India Standard Time).
Here It understands the continental Indian time zone abbreviations, but for general use, use a time zone offset.

DATESTRING("2/3/1998") = Tue Feb 03 1998 00:00:00 GMT+0530 (India Standard Time)
DATESTRING("10/2/2019") = Wed Oct 02 2019 00:00:00 GMT+0530 (India Standard Time)
DATESTRING("5/4/2100") = Tue May 04 2100 00:00:00 GMT+0530 (India Standard Time)