https://bugs.documentfoundation.org/show_bug.cgi?id=149950
--- Comment #5 from [email protected] --- (In reply to Eike Rathke from comment #3) > (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. But I add "D M Y" to the acceptance patterns so that is does recognise it. Without that datevalue("02 03 2020") return Err:502, but with it, it returns the date value 43892. The problem is that 2 Mar 2020 is a proper date and it should be recognised as such. If I switch to en-US, then "Mar 2, 2020" is recognised. Therefor under en-ZA "2 Mar 2020" should be recognised too, but it isn't, regardless of the acceptance pattern added. > What LibreOffice version are you using anyway? Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_ZA.UTF-8); UI: en-US Ubuntu package version: 1:7.3.4~rc2-0ubuntu0.20.04.1~lo1 -- You are receiving this mail because: You are the assignee for the bug.
