Re: [office] Problems with DAY, MONTH and YEAR functions

[Michael Stahl <michael.stahl@allotropia.de>]

On 16/10/2023 20:26, Michael Stahl wrote:
> except if we read it as DateParam constrains it (if it is a Number) to a 
> Date without fractional part, then "return it" will also return in a 
> Date of course.

no, i was confused here: the definition of DateParam is:
"either a Number (interpreted as a serial number; 4.3.3) or Text"

so the Number need not be Date, it may be DateTime.

DATETIMEVALUE.ROUND function may be an option, not sure if you like 1 or 
2 functions better :)


--
Michael Stahl
Senior Software-Entwickler LibreOffice
âââ
allotropia software GmbH
Versmannstr. 4
20457 Hamburg
Germany
âââ
michael.stahl@allotropia.de
https://www.allotropia.de
âââ
Registered office: Hamburg, Germany
Registration court Hamburg, HRB 165405
Managing director: Thorsten Behrens
VAT-ID: DE 335606919
âââ