https://bugs.freedesktop.org/show_bug.cgi?id=63437
--- Comment #5 from mariosv <[email protected]> --- Hi Foss, you can reopen if you like, but there is no bug. LibreOffice help: " DATEVALUE Returns the internal date number for text in quotes. The internal date number is returned as a number. The number is determined by the date system that is used by LibreOffice to calculate dates. If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion. Syntax DATEVALUE("Text") Text is a **valid date expression and must be entered with quotation marks**. Example =DATEVALUE("1954-07-20") yields 19925. " Partial input dates are only accepted when entering dates by hand in a cell, with the patterns for the selected language. If Michel want the day of today, if can modify the formula: =DATEVALUE(E2&"/"&DAY(TODAY())) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
