Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-04-2024, 11:53 AM   #751
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 9,532
Karma: 64960939
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
It's not particularly important - just that ideally I was hoping that ColourA would only appear for the current date (e.g. it switches to ColourB at midnight).
ownedbycats is offline   Reply With Quote
Old Yesterday, 07:15 PM   #752
correoparaappzz
Enthusiast
correoparaappzz began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Nov 2023
Device: Kindle Oasis


hi, i'm having problems with this template:
Code:
program:
    format_date($#pubdate, 'dd MMMM yyyy')
for some books post's 'BAD DATE', and don't know what to do
correoparaappzz is offline   Reply With Quote
Old Yesterday, 07:16 PM   #753
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 9,532
Karma: 64960939
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Do you get the same results if you use $$#pubdate? $ is field, $$ is raw_field.
ownedbycats is offline   Reply With Quote
Old Yesterday, 07:57 PM   #754
correoparaappzz
Enthusiast
correoparaappzz began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Nov 2023
Device: Kindle Oasis
Quote:
Originally Posted by ownedbycats View Post
Do you get the same results if you use $$#pubdate? $ is field, $$ is raw_field.
it worked, but now there's a problem with the sorting order
Attached Thumbnails
Click image for larger version

Name:	Captura de pantalla 2024-11-05 155513.png
Views:	8
Size:	36.8 KB
ID:	211872  
correoparaappzz is offline   Reply With Quote
Old Yesterday, 08:09 PM   #755
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 9,532
Karma: 64960939
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Try going to the add custom columns dialog and editing the column to set the sort to 'date.'
ownedbycats is offline   Reply With Quote
Old Yesterday, 08:27 PM   #756
correoparaappzz
Enthusiast
correoparaappzz began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Nov 2023
Device: Kindle Oasis
Quote:
Originally Posted by ownedbycats View Post
Try going to the add custom columns dialog and editing the column to set the sort to 'date.'
This is how the column is configured
Attached Thumbnails
Click image for larger version

Name:	Captura de pantalla 2024-11-05 162538.png
Views:	18
Size:	26.2 KB
ID:	211873  
correoparaappzz is offline   Reply With Quote
Old Yesterday, 08:33 PM   #757
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 9,532
Karma: 64960939
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
I'm not sure then - I seem to recall there were some oddities with the date sorting but I'm not sure if its the case here. @chaley?
ownedbycats is offline   Reply With Quote
Old Yesterday, 10:45 PM   #758
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,029
Karma: 7257323
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
The problem is that the date is in non-English text. Sorting composites by date only works with English dates, and then only in most cases. The reliable solution is to sort the source column, pubdate.

I suspect a better solution would be to supply a format for pubdate (using a tweak) instead of creating a composite column.
chaley is offline   Reply With Quote
Old Yesterday, 10:47 PM   #759
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 9,532
Karma: 64960939
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Would non-English also explain the BAD DATE error when using field()?

Last edited by ownedbycats; Yesterday at 10:49 PM.
ownedbycats is offline   Reply With Quote
Old Yesterday, 11:02 PM   #760
correoparaappzz
Enthusiast
correoparaappzz began at the beginning.
 
Posts: 38
Karma: 10
Join Date: Nov 2023
Device: Kindle Oasis
Quote:
Originally Posted by chaley View Post
The problem is that the date is in non-English text. Sorting composites by date only works with English dates, and then only in most cases. The reliable solution is to sort the source column, pubdate.

I suspect a better solution would be to supply a format for pubdate (using a tweak) instead of creating a composite column.


I think this is a better option for what I was trying to do.
correoparaappzz is offline   Reply With Quote
Old Yesterday, 11:09 PM   #761
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,029
Karma: 7257323
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
Would non-English also explain the BAD DATE error when using field()?
Yes, it would.
chaley is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Library Management: various questions not worth their own thread ownedbycats Library Management 173 Yesterday 11:43 PM
[Metadata Source Plugin] Questions regarding parse select, docs and ref templates Boilerplate4U Development 13 07-07-2020 03:35 AM
Questions on Kobo [Interfered with another thread topic] spdavies Kobo Reader 8 10-12-2014 12:37 PM
[OLD Thread] Some questions before buying the fire. darthreader13 Kindle Fire 7 05-10-2013 10:19 PM
Thread management questions meme Feedback 6 01-31-2011 06:07 PM


All times are GMT -4. The time now is 10:00 AM.


MobileRead.com is a privately owned, operated and funded community.