Description:
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.

CDate Function:
Replace the string

in the format MM.DD.YYYY HH.MM.SS, as defined by the DateValue and TimeValue function conventions

by

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.

DateValue Function:
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:
-

Actual Results:  
-

Expected Results:
-


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0