View Single Post
Old 12-26-2019, 01:24 PM   #1
vikarti
Groupie
vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.vikarti ought to be getting tired of karma fortunes by now.
 
Posts: 180
Karma: 1004974
Join Date: May 2013
Location: Solar system, Earth
Device: none
Strange issue with date sorting - CC thinks nobody reads books after midday?

Configuration (I try to list everything that could be important):
Calibre 4.6 on macOS Mojave. Russian locale.
Galaxy Note 9 with Russian locale.
CC version 5.4.3.3 (391). Automatically switched to Russian language.

Sync column for Date Read: #dateread , this column defined as dd MMM yyyy hh:mm:ss (not default dd MMM yyy)

#dateread is also being used as grouping/sorting column sometimes.

Here lies problem:

I configure calibre to sort by #dateread, first book
Calibre sees: 26 дек 2019 23:22:24 ("дек" is correct abbrev. for December, no issues here)
but connected CC sees 26 Dec 2019 11:22:42 and it's not first book in CC (book with #dateread 26 Dec 2019 5:12:49 (per CC) (26 дек 2019 17:12:49 per Calibre) is before. And so on.
So sorting in Calibre and CC appears to differ if date column value is in 12-24 hours (and not 0-11) range.

Changing #dateread format in Calibre to dd MMM yyyy hh:mm:ss AP messes up CC's parser and it stars to show up datetimes in iso format but with +0 offset.

Changing #dateread format in Calibre to dd-MM-yyyy hh:mm:ss so Calibre now shows 26-12-2019 23:22:42 as date results in same issue except that CC shows 26-12-2019 11:22:42 )

How to make CC correctly show books I read after midday as such?

upd:
restored format to dd MMM yyyy hh:mm:ss
Read another book in CC (and Moon+) and synced. Calibre's #dateread column now shows 27 Дек 2019 00:29:43, CC shows 27/Dec/2019 12:29:43 (Opened (CC) shows 27 Dec 2019 12:30 AM which at least clear that we are speaking about AM/PM here)
upd:
5.4.4.1 (392) from http://charles.the-haleys.org/CC_Updates/ (and not Play Store) works exactly same in this regard

Last edited by vikarti; 12-26-2019 at 02:02 PM. Reason: note about 4.4.4
vikarti is offline   Reply With Quote