https://bugs.documentfoundation.org/show_bug.cgi?id=149950
--- Comment #3 from Eike Rathke <[email protected]> --- (In reply to Mike Kaganski from comment #1) > I believe that date acceptance pattern is not meant to affect function > results. Date acceptance patterns do affect DATEVALUE(), as the argument is just passed to the number formatter/scanner's IsNumberFormat() with all its quirks and bells and whistles, that parses it according to the current locale and settings. (In reply to roland from comment #0) > datevalue("02 Mar 2020) returns "Err:502" > datevalue("02 03 2020") returns "43892", which is correct. I can not reproduce. I tried in an en-ZA locale with its default date acceptance patterns Y-M-D;Y/M/D;M-D;M/D and both formula expressions return Err:502 and the same strings as cell inputs are also not accepted as dates but stay text. What LibreOffice version are you using anyway? (In reply to roland from comment #2) > Maybe it's time then to integrate the > datevalue() code with the code that does the validation of input? Or to let > them both use the same logic at least. It does exactly that. -- You are receiving this mail because: You are the assignee for the bug.
