Re: Fwd: [libreoffice-users] macro to only change month

2018-01-28 9:04 GMT+01:00 Brian Barker <b.m.barker@btinternet.com>:

> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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