[OASIS Issue Tracker] Updated: (OFFICE-1052) Public Comment: ODFF:DAYS360

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ http://tools.oasis-open.org/issues/browse/OFFICE-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-1052:
--------------------------------

    Proposal: 
For the 30US/360 method:

1. Truncate date values, set sign=1.

2. If StartDate's day-of-month is 31, it is changed to 30.

3. Otherwise, if StartDate's day-of-month is the last day of February, it is changed to 30.

4. If EndDate's day-of-month is 31 and StartDate's day-of-month is 30 (after having applied a change for #2 or #3, if necessary), EndDate's day-of-month is changed to 30.

Note: This calculation is slightly different from Basis 0 (3.11.6 Basis). Dates are never swapped.


For the 30E/360 method insert:

1. Truncate date values, set sign=1.

2. If StartDate is after EndDate then swap dates and set sign=-1.

3. If StartDate's day-of-month is 31, it is changed to 30.

4. If EndDate's day-of-month is 31, it is changed to 30.

Note: Days in February are never changed.

Note: This calculation is identical to Basis 4 (3.11.6 Basis)


After both methods:

For both methods the value then returned is
sign * ((EndDate.year*360 + EndDate.month*30 + EndDate.day) - (StartDate.year*360 + StartDate.month*30 + StartDate.day))


  was:
In Semantics, add to both methods:

1. If StartDate > EndDate then swap dates.

Add note to 30US/360 method:

Note: Some evaluators do not swap dates if StartDate > EndDate and therefor treat some combinations of dates falling on the last day of a month incorrectly.



> Public Comment: ODFF: DAYS360
> -----------------------------
>
>                 Key: OFFICE-1052
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1052
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Robert Weir 
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 Part 2 CD 3
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com> 
> Original date: 12 Aug 2008 22:00:01 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00022.html
> From that comment mail:
> DAYS360 and financial date systems
> * Consider whether to specify compliance with the Excel NASD date bug  or introduce a switch for NASD compliance. The bug has to be mentioned I think.
> * The date systems implemented by Excel and specified by ODFF are only a subset of date systems used in practice, which might be worth noting.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira