OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Re: [office] ODF TC Teleconference Agenda for September 10, 2018


Regina,


On 09/09/2018 01:27 PM, Regina Henschel wrote:
> Hi Patrick,
>
> Patrick Durusau schrieb am 09-Sep-18 um 15:47:
> [..]
>>
>> c. Francis Cave also raised a possible issue with the date and time
>> functions in part 4, 6.10 Date and Time Functions
>>
>> Our discussion started on 6.10.5 DAY,
>
> Can you please point me to "our discussion" ?
>
I was reporting a discussion with Francis Cave where this issue was
informally mentioned. The gist of it is as reported in my email.

> Âwhere the summary reads: "Returns the date from a date."
>
> "Summary: Returns the day from a date.", both in standard and working
> draft.
>
> Âand the Semantics reads: "Returns the day portion of a date."
>
>
>>
>> We do have a DATE function, Summary: Constructs a date from year,
>> month, and day of the month." which goes on to define the syntax, but
>> the definition of DAY, does not refer to this function.
>
> The DATE function my be evaluated for values for month and day, which
> do not really exists, e.g. "=DATE(2018;8;33)", which will give
> "2018-09-02" in ISO date format. And the DATE function results in a
> number, that get a "day portion" only by formatting. Therefore I
> suggest not to use the DATE function in a reference.
>
>>
>> Question: Should this be a reference to "Date" in 4.3.3, but then
>> should 4.3.3 define year, month and day "portions?" I think the
>> present text assumes year-month-day but it doesn't explicitly say that.
>
> I think, that "day portion" is clear enough. In case you want a
> reference to a year-month-day notation, we can use the notation
> description for office:value-type="date" (ODF 1.2 part 1, Â19.385).
>
Thanks!

> BTW, I'm more concerned, that a hint is missing, that the values of
> these functions depend on the <table:null-date> element; perhaps
> something to consider for Â6.10.1 General for ODF 1.4.
>
Thanks!

Hope you are having a great weekend!

Patrick


> Kind regards
> Regina
>
> ---------------------------------------------------------------------
> To unsubscribe from this mail list, you must leave the OASIS TC that
> generates this mail. Follow this link to all your TCs in OASIS at:
> https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php

-- 
Patrick Durusau
patrick@durusau.net
Technical Advisory Board, OASIS (TAB)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau 


Attachment: signature.asc
Description: OpenPGP digital signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]