[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1052) Public Comment: ODFF:DAYS360
[ 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]