Date acceptance patterns depending of the locale setting have been introduced in LibO, it seems, already some years ago. Some date functions which were affected by this, seem to have been changed accordingly, as they reject dates in formats not fitting these patterns – or the ISO format. The help texts for these functions still reflect the former situation.
I propose the following changes for the help texts. There is also a reserve condition saying that only one of the two ISO formats is accepted for the moment, which could perhaps be removed in the future if bug 106956 is resolved, allowing also the other format.
Replace the string
in the format MM.DD.YYYY HH.MM.SS, as defined by the DateValue and TimeValue function conventions
either in one of the date acceptance patterns defined for your locale setting (see *Tools - Options - Language Settings - Languages*) or in ISO date format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31") is accepted.
Replace the text starting from
The date can be specified in almost any format.
and containing all the rest of the description of parameter „Date“, i.e. up to just before „Error Codes“, by
In contrast to the DateSerial function that passes years, months and days as separate numeric values, the DateValue function requests the date string to be according to either one of the date acceptance patterns defined for your locale setting (see *Tools - Options - Language Settings - Languages*) or to ISO date format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31") is accepted.
(The text concerning the decimal separator is irrelevant here.)
Steps to Reproduce:
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Submitted patch with corrections proposed.
Kindly verify if the text is correct.
Both patches contain the text exactly as proposed.
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":
tdf#106957 - outdated doc for BASIC date functions
A polite ping to Olivier Hallot: is this bug fixed? if so, please close it as RESOLVED FIXED