emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* erroneous clocktable for November 2018 - possible DST problem
@ 2018-11-17  8:06 Jeff Trull
  2018-11-17 20:50 ` Nicolas Goaziou
  0 siblings, 1 reply; 3+ messages in thread
From: Jeff Trull @ 2018-11-17  8:06 UTC (permalink / raw)
  To: emacs-orgmode


[-- Attachment #1.1: Type: text/plain, Size: 9988 bytes --]

Clocktables containing work in November of 2018 are reported incorrectly,
showing the wrong day (typically one earlier than the correct date). For
example, in the attached repro.org, work is performed on the 3rd and 5th of
November, but when daily reports are used in the clocktable the work on 5
November is reported as occurring on 4 November. Reporting 1-4 November and
5-30 November separately works around the problem.

In the US, Daylight Savings ended on 4 November; this fact plus a previous
problem (reported here:
https://stackoverflow.com/questions/42821604/why-is-emacs-org-mode-missing-one-date-from-clocktable)
suggests DST is involved.

Thanks and Regards,
Jeff Trull

Emacs  : GNU Emacs 25.2.2 (x86_64-pc-linux-gnu, GTK+ Version 3.23.2)
 of 2018-08-27, modified by Debian
Package: Org mode version 9.1.14 (9.1.14-9-g131531-elpa @
/home/jet/.emacs.d/elpa/org-20181112/)

current state:
==============
(setq
 org-export-backends '(confluence md latex icalendar html ascii)
 org-tab-first-hook '(org-babel-hide-result-toggle-maybe
org-babel-header-arg-expand)
 org-speed-command-hook '(org-speed-command-activate
org-babel-speed-command-activate)
 org-occur-hook '(org-first-headline-recenter)
 org-metaup-hook '(org-babel-load-in-session-maybe)
 org-html-format-drawer-function '(closure
                                   (htmlize-buffer-places
org-html-format-table-no-css
                                    htmlize-css-name-prefix
htmlize-output-type htmlize-output-type
                                    htmlize-css-name-prefix t)
                                   (_name contents) contents)
 org-latex-format-inlinetask-function
'org-latex-format-inlinetask-default-function
 org-duration-format 'h:mm
 org-confirm-shell-link-function 'yes-or-no-p
 org-ascii-format-inlinetask-function 'org-ascii-format-inlinetask-default
 org-latex-format-headline-function
'org-latex-format-headline-default-function
 org-latex-listings-options '(("keywordstyle" "\\color{keywordcolor}")
                              ("basicstyle" "\\footnotesize\\ttfamily")
                              ("backgroundcolor" "\\color{backcolor}")
("showstringspaces" "false")
                              ("moredelim"

 "**[is][\\only<+>{\\color{black}\\lstset{style=highlight}}]{@}{@}")
                              ("breaklines" "true"))
 org-after-todo-state-change-hook '(org-clock-out-if-current)
 org-latex-format-drawer-function '(closure (t) (_ contents) contents)
 org-odt-format-headline-function 'org-odt-format-headline-default-function
 org-from-is-user-regexp "\\<Jeff Trull\\>"
 org-src-mode-hook '(org-src-babel-configure-edit-buffer
org-src-mode-configure-edit-buffer)
 org-agenda-before-write-hook '(org-agenda-add-entry-text)
 org-babel-pre-tangle-hook '(save-buffer)
 org-mode-hook '(#[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook org-show-block-all
append local] 5]
                 #[0 "\300\301\302\303\304$\207"
                   [add-hook change-major-mode-hook
org-babel-show-result-all append local] 5]
                 (closure
                  (org-inlinetask-min-level buffer-face-mode-face
org-struct-menu org-last-state
                   org-id-track-globally texmathp-why remember-data-file
                   org-agenda-tags-todo-honor-ignore-options
iswitchb-temp-buflist
                   calc-embedded-open-mode calc-embedded-open-formula
calc-embedded-close-formula
                   align-mode-rules-list ffap-url-regexp t)
                  nil
                  (add-hook (quote change-major-mode-hook) (quote
org-show-block-all)
                   (quote append) (quote local))
                  )
                 (closure (*this* org-babel-confirm-evaluate-answer-no t)
nil
                  (add-hook (quote change-major-mode-hook) (quote
org-babel-show-result-all)
                   (quote append) (quote local))
                  )
                 (closure
                  (org-inlinetask-min-level buffer-face-mode-face
org-mode-map org-tbl-menu
                   org-org-menu org-struct-menu org-entities org-last-state
org-id-track-globally
                   org-clock-start-time texmathp-why remember-data-file
                   org-agenda-tags-todo-honor-ignore-options
iswitchb-temp-buflist
                   calc-embedded-open-mode calc-embedded-open-formula
calc-embedded-close-formula
                   align-mode-rules-list org-emphasis-alist
org-emphasis-regexp-components
                   org-export-registered-backends org-modules
org-babel-load-languages
                   org-element-paragraph-separate ffap-url-regexp t)
                  nil
                  (add-hook (quote change-major-mode-hook) (quote
org-show-block-all)
                   (quote append) (quote local))
                  )
                 (closure
                  (org-bracket-link-regexp org-src-window-setup *this*
                   org-babel-confirm-evaluate-answer-no
org-src-preserve-indentation
                   org-src-lang-modes org-edit-src-content-indentation
org-babel-library-of-babel t)
                  nil
                  (add-hook (quote change-major-mode-hook) (quote
org-babel-show-result-all)
                   (quote append) (quote local))
                  )
                 org-babel-result-hide-spec org-babel-hide-all-hashes
org-eldoc-load)
 org-bibtex-headline-format-function '(closure
                                       (org-id-locations
org-agenda-search-view-always-boolean
                                        org-agenda-overriding-header t)
                                       (entry) (cdr (assq :title entry)))
 org-archive-hook '(org-attach-archive-delete-maybe)
 org-ascii-format-drawer-function '(closure (t) (_name contents _width)
contents)
 org-odt-format-inlinetask-function
'org-odt-format-inlinetask-default-function
 org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers
                  org-cycle-show-empty-lines
org-optimize-window-after-visibility-change)
 org-html-creator-string "<a
href=\"https://www.gnu.org/software/emacs/\">Emacs</a>
25.2.2 (<a href=\"https://orgmode.org\">Org</a> mode 9.1.13)"
 org-latex-packages-alist '(("" "moresize" t) ("" "fancyvrb" t) (""
"inconsolata" t) ("" "tikz" t)
                            ("" "color" t) ("" "listings" t))
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 org-odt-format-drawer-function '(closure
                                  (hfy-user-sheet-assoc
hfy-html-quote-regex hfy-html-quote-map
                                   hfy-face-to-css hfy-begin-span-handler
hfy-end-span-handler
                                   archive-zip-extract
nxml-auto-insert-xml-declaration-flag t)
                                  (_name contents) contents)
 org-latex-listings t
 org-html-format-headline-function
'org-html-format-headline-default-function
 org-link-parameters '(("id" :follow org-id-open)
                       ("rmail" :follow org-rmail-open :store
org-rmail-store-link)
                       ("mhe" :follow org-mhe-open :store
org-mhe-store-link)
                       ("irc" :follow org-irc-visit :store
org-irc-store-link)
                       ("info" :follow org-info-open :export
org-info-export :store
                        org-info-store-link)
                       ("gnus" :follow org-gnus-open :store
org-gnus-store-link)
                       ("docview" :follow org-docview-open :export
org-docview-export :store
                        org-docview-store-link)
                       ("bibtex" :follow org-bibtex-open :store
org-bibtex-store-link)
                       ("bbdb" :follow org-bbdb-open :export
org-bbdb-export :complete
                        org-bbdb-complete-link :store org-bbdb-store-link)
                       ("w3m" :store org-w3m-store-link) ("file+sys")
("file+emacs")
                       ("ipynb" :follow ein:org-open :help-echo "Open
ipython notebook." :store
                        ein:org-store-link)
                       ("doi" :follow org--open-doi-link) ("elisp" :follow
org--open-elisp-link)
                       ("file" :complete org-file-complete-link)
                       ("ftp" :follow (lambda (path) (browse-url (concat
"ftp:" path))))
                       ("help" :follow org--open-help-link)
                       ("http" :follow (lambda (path) (browse-url (concat
"http:" path))))
                       ("https" :follow (lambda (path) (browse-url (concat
"https:" path))))
                       ("mailto" :follow (lambda (path) (browse-url (concat
"mailto:" path))))
                       ("news" :follow (lambda (path) (browse-url (concat
"news:" path))))
                       ("shell" :follow org--open-shell-link))
 org-structure-template-alist '(("n" "#+BEGIN_NOTES\n?\n#+END_NOTES")
                                ("s" "#+BEGIN_SRC ?\n\n#+END_SRC")
                                ("e" "#+BEGIN_EXAMPLE\n?\n#+END_EXAMPLE")
                                ("q" "#+BEGIN_QUOTE\n?\n#+END_QUOTE")
                                ("v" "#+BEGIN_VERSE\n?\n#+END_VERSE")
                                ("V" "#+BEGIN_VERBATIM\n?\n#+END_VERBATIM")
                                ("c" "#+BEGIN_CENTER\n?\n#+END_CENTER")
                                ("C" "#+BEGIN_COMMENT\n?\n#+END_COMMENT")
                                ("l" "#+BEGIN_EXPORT
latex\n?\n#+END_EXPORT") ("L" "#+LaTeX: ")
                                ("h" "#+BEGIN_EXPORT
html\n?\n#+END_EXPORT") ("H" "#+HTML: ")
                                ("a" "#+BEGIN_EXPORT
ascii\n?\n#+END_EXPORT") ("A" "#+ASCII: ")
                                ("i" "#+INDEX: ?") ("I" "#+INCLUDE: %file
?"))
 org-export-creator-string "Emacs 25.2.2 (Org mode 9.1.13)"
 org-reveal-title-slide "<h2>%t</h2><h2>%a</h2><h2>%d</h2>"
 org-html-format-inlinetask-function
'org-html-format-inlinetask-default-function
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 )

[-- Attachment #1.2: Type: text/html, Size: 14129 bytes --]

[-- Attachment #2: repro.org --]
[-- Type: application/octet-stream, Size: 1726 bytes --]

#+TITLE: Reproducing clock table problem

* Task A
  :LOGBOOK:
  CLOCK: [2018-11-03 Sat 12:00]--[2018-11-03 Sat 14:00] =>  2:00
  - Work 
  CLOCK: [2018-11-05 Mon 12:00]--[2018-11-05 Mon 14:00] =>  2:00
  - More work 
  :END:
* Task B
  :LOGBOOK:
  CLOCK: [2018-11-03 Sat 14:00]--[2018-11-03 Sat 16:00] =>  2:00
  - Work 
  CLOCK: [2018-11-05 Mon 14:00]--[2018-11-05 Mon 16:00] =>  2:00
  - More work 
  :END:

** Wrong Clocktable
#+BEGIN: clocktable :scope file :maxlevel 4 :block 2018-11 :stepskip0 t :step day

Daily report: [2018-11-03 Sat]
| Headline     |   Time |
|--------------+--------|
| *Total time* | *4:00* |
|--------------+--------|
| Task A       |   2:00 |
| Task B       |   2:00 |

# This work happened on the 5th, not the 4th!
Daily report: [2018-11-04 Sun]
| Headline     |   Time |
|--------------+--------|
| *Total time* | *4:00* |
|--------------+--------|
| Task A       |   2:00 |
| Task B       |   2:00 |

#+END:

** Correct (but separate) Clocktables
# The November period, when broken up into two ranges, now looks correct:

#+BEGIN: clocktable :scope file :maxlevel 4 :tstart "<2018-11-01>" :tend "<2018-11-04>" :stepskip0 t :step day

Daily report: [2018-11-03 Sat]
| Headline     |   Time |
|--------------+--------|
| *Total time* | *4:00* |
|--------------+--------|
| Task A       |   2:00 |
| Task B       |   2:00 |
#+END:

#+BEGIN: clocktable :scope file :maxlevel 4 :tstart "<2018-11-05>" :tend "<2018-11-30>" :stepskip0 t :step day
# This now shows work done on the 5th, the correct day:
Daily report: [2018-11-05 Mon]
| Headline     |   Time |
|--------------+--------|
| *Total time* | *4:00* |
|--------------+--------|
| Task A       |   2:00 |
| Task B       |   2:00 |

#+END:

^ permalink raw reply	[flat|nested] 3+ messages in thread
end of thread, other threads:[~2018-11-18  7:23 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-11-17  8:06 erroneous clocktable for November 2018 - possible DST problem Jeff Trull
2018-11-17 20:50 ` Nicolas Goaziou
2018-11-18  7:22   ` Jeff Trull

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).