https://bugs.documentfoundation.org/show_bug.cgi?id=170107
--- Comment #2 from Jeff Fortin Tam <[email protected]> --- Created attachment 204985 --> https://bugs.documentfoundation.org/attachment.cgi?id=204985&action=edit Screenshot of the DATEVALUE function's in-GUI documentation Well there are two problems with that, as can be seen in this screenshot: * The DATEVALUE function does not specify the accepted format(s) in the GUI's formula editor built-in contextual documentation. * As far as I can tell, there is no "other function" in Calc to convert different date formats to the ISO 8601 format that DATEVALUE currently parses, so there is zero solution for users who have to parse data, unlike in Excel. The fact that the standard mandates that "This function shall accept ISO date format" makes a lot of sense (as it is the only date format that you can truly internationally standardize on) but does not preclude the app being more lenient in what it accepts to parse. i.e. https://en.wikipedia.org/wiki/Robustness_principle -- You are receiving this mail because: You are the assignee for the bug.
