Last modified by Helena on 2025/09/10 11:19

From version 4.3
edited by Helena
on 2025/05/16 11:15
Change comment: There is no comment for this version
To version 4.6
edited by Helena
on 2025/05/16 11:22
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -260,7 +260,7 @@
260 260  
261 261  Representation: common:ReportingWeekType (YYYY-Www, e.g. 2000-W53)
262 262  
263 -Notes: There are either 52 or 53 weeks in a reporting year. This is based on the ISO 8601 definition of a week (Monday - Saturday), where the first week of a reporting year is defined as the week with the first Thursday on or after the reporting year start day.^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^3^^>>path:#sdfootnote3sym||name="sdfootnote3anc"]](%%)^^ The reporting week is always represented as two digits, therefore 1-9 are 0 padded (e.g. 01). This allows the values to be sorted chronologically using textual sorting methods.
263 +Notes: There are either 52 or 53 weeks in a reporting year. This is based on the ISO 8601 definition of a week (Monday - Saturday), where the first week of a reporting year is defined as the week with the first Thursday on or after the reporting year start day.^^[[(% class="wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink wikiinternallink" %)^^3^^>>path:#sdfootnote3sym||name="sdfootnote3anc"]](%%)^^ The reporting week is always represented as two digits, therefore 1-9 are 0 padded (e.g. 01). This allows the values to be sorted chronologically using textual sorting methods.
264 264  
265 265  **Reporting Day**:
266 266  
... ... @@ -288,16 +288,14 @@
288 288  This is the [REPORTING_YEAR_START_DATE]
289 289  
290 290  **a) If the [PERIOD_INDICATOR] is W:**
291 -~1. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday**:
292 292  
293 -Add{{footnote}}The rules for adding durations to a date time are described in the W3C XML Schema specification. See http://www.w3.org/TR/xmlschema-2/#adding-durations-to-dateTimes for further details.{{/footnote}} (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
292 + ~1. **If [REPORTING_YEAR_START_DATE] is a Friday, Saturday, or Sunday**:
293 + Add{{footnote}}The rules for adding durations to a date time are described in the W3C XML Schema specification. See http://www.w3.org/TR/xmlschema-2/#adding-durations-to-dateTimes for further details.{{/footnote}} (P3D, P2D, or P1D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
294 294  
295 -**2. If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
295 +**~ 2. If [REPORTING_YEAR_START_DATE] is a Monday, Tuesday, Wednesday, or Thursday:**
296 + Add^^4^^ (P0D, -P1D, -P2D, or -P3D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
296 296  
297 -Add^^4^^ (P0D, -P1D, -P2D, or -P3D respectively) to the [REPORTING_YEAR_START_DATE]. The result is the [REPORTING_YEAR_BASE].
298 -
299 299  **b) Else:**
300 -
301 301  The [REPORTING_YEAR_START_DATE] is the [REPORTING_YEAR_BASE].
302 302  
303 303  **2. Determine [PERIOD_DURATION]:**
... ... @@ -321,53 +321,34 @@
321 321  **Examples:**
322 322  
323 323  **2010-Q2, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)**
322 +~1. [REPORTING_YEAR_START_DATE] = 2010-07-01
323 + b) [REPORTING_YEAR_BASE] = 2010-07-01
324 +2. [PERIOD_DURATION] = P3M
325 +3. (2-1) * P3M = P3M
326 + 2010-07-01 + P3M = 2010-10-01
327 + [PERIOD_START] = 2010-10-01
324 324  
325 -1. [REPORTING_YEAR_START_DATE] = 2010-07-01
329 +4. 2 * P3M = P6M
330 + 2010-07-01 + P6M = 2010-13-01 = 2011-01-01
331 + 2011-01-01 + -P1D = 2010-12-31
332 + [PERIOD_END] = 2010-12-31
326 326  
327 -b) [REPORTING_YEAR_BASE] = 2010-07-01
328 -
329 -1. [PERIOD_DURATION] = P3M
330 -1. (2-1) * P3M = P3M
331 -
332 -2010-07-01 + P3M = 2010-10-01
333 -
334 -[PERIOD_START] = 2010-10-01
335 -
336 -1. 2 * P3M = P6M
337 -
338 -2010-07-01 + P6M = 2010-13-01 = 2011-01-01
339 -
340 -2011-01-01 + -P1D = 2010-12-31
341 -
342 -[PERIOD_END] = 2010-12-31
343 -
344 344  The actual calendar range covered by 2010-Q2 (assuming the reporting year begins July 1) is 2010-10-01T00:00:00/2010-12-31T23:59:59
345 345  
346 346  **2011-W36, REPORTING_YEAR_START_DAY = ~-~-07-01 (July 1)**
337 +~1. [REPORTING_YEAR_START_DATE] = 2010-07-01
338 + a) 2011-07-01 = Friday
339 + 2011-07-01 + P3D = 2011-07-04
340 + [REPORTING_YEAR_BASE] = 2011-07-04
341 +2. [PERIOD_DURATION] = P7D
342 +3. (36-1) * P7D = P245D
343 + 2011-07-04 + P245D = 2012-03-05
344 + [PERIOD_START] = 2012-03-05
345 +4. 36 * P7D = P252D
346 + 2011-07-04 + P252D =2012-03-12
347 + 2012-03-12 + -P1D = 2012-03-11
348 + [PERIOD_END] = 2012-03-11
347 347  
348 -1. [REPORTING_YEAR_START_DATE] = 2010-07-01
349 -
350 -a) 2011-07-01 = Friday
351 -
352 -2011-07-01 + P3D = 2011-07-04
353 -
354 -[REPORTING_YEAR_BASE] = 2011-07-04
355 -
356 -1. [PERIOD_DURATION] = P7D
357 -1. (36-1) * P7D = P245D
358 -
359 -2011-07-04 + P245D = 2012-03-05
360 -
361 -[PERIOD_START] = 2012-03-05
362 -
363 -1. 36 * P7D = P252D
364 -
365 -2011-07-04 + P252D =2012-03-12
366 -
367 -2012-03-12 + -P1D = 2012-03-11
368 -
369 -[PERIOD_END] = 2012-03-11
370 -
371 371  The actual calendar range covered by 2011-W36 (assuming the reporting year begins July 1) is 2012-03-05T00:00:00/2012-03-11T23:59:59
372 372  
373 373  === {{id name="_Toc291513"/}}4.2.7 Distinct Range ===