2018-01-28 9:04 GMT+01:00 Brian Barker <[email protected]>:
> At 08:52 28/01/2018 +0100, Johnny Rosenberg wrote:
>
>> For some strange reason you need to make sure you enter valid values for
>> month and day. In Excel (which sucks in most aspects, but I have to use it
>> at work) you can do things like DateSerial(2017, 13, 59), which returns the
>> date value for 2018-02-28, but that seems to throw an error in LibreOffice.
>> That's odd, or at least primitive, I think. It would be very convenient not
>> having to think about those boundaries, just increase the month number and
>> it just works. Maybe I should file a bug report or enhancement request
>> about that…
>>
>
> Does =DATE(2017;13;59) not give 2018-02-28 for you?
>
Yes, it does. I was referring to the Basic function DateSerial:
Sub Main
Print DateSerial(2017,13,59) ' Gives error message.
End Sub
>
> Brian Barker
>
> --
> To unsubscribe e-mail to: [email protected]
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
> subscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
