How to do a Year Category?

[iksi]

Greetings!

I'm trying to do a new category for my collection: "Year Published".
I don't know how to do it. I got error when I tried, but I did manage to make a 'genre' -category.

- It should get the values from Published -field, if one exists.
- No need to have month / day.

I'd like it to look like this:
>Year

> ??? [No year found]
> ...
> 1980
> 1981
> ...
> 2020

> $Author

Is this doable? Thanks.

[georgemk]

Is this what you had in mind
How to make calibre published date only years not m+y

[iksi]

Almost. I forgot to say that I want it to be applied into the "tag browser".

[georgemk]

Sorry no idea how to do that part. Hopefully some one else will be along who does know how.

[BetterRed]

@iksi - dates and numbers don't appear in the Tag Browser

But something like this should work - untested



You will probably have to do some formatting in the template to extract the year only, see ==>> The calibre template language

BR

[uli]

I found this fancier version grouped by decades:

{pubdate:'test($,
strcat(substr(format_date($,'yyyy'), 0, 1), '000.',substr(format_date($,'yyyy'), 0, 3), '0.',format_date($,'yyyy')),
'Unknown')'}

Tip: don't forget you can click twice on a node to see all that decade, century

[dunhill]

I do not have it so complete but it gives me the same result. We go to Preferences / Add Custom columns and create a column generated from another column and in the template add the formula described in the image. We accept and restart Calibre.

[iksi]

Thanks for the suggestions , but so far, I can't get them to work .

uli's suggestion gives these weird "1000.1000.1000" sets? They seem to be grouped correctly, but the format is odd.

dunhill's suggestion gives me "Unknown Function".

I have version 5.0.1 running on the latest Ubuntu. Maybe there've been some changes?

[jbacelar]

I have created a text column to have the year of the original publication.
In principle I fill it with the pubdate date, and then I correct it if necessary in cases like these:
Dates before our era: -150
Books containing several works with a date range: 1850-65
Hence the need for it to be a text column.

[chaley]

This template produces what you want

{pubdate:'ifempty(format_date($, 'yyyy'), '???')'}

put it in a 'Column built from other columns', Check the "Show in tag browser' box. Set the "Search/sort column" type to numeric.

[uli]

Forgot you need to set it to hierarchical, also I think you might need to remove partitions for that category.

[iksi]

Thank you everyone!

chaley's method works and is simple enough for me to understand.

[dunhill]

I have modified the syntax to my liking being like this.
{pubdate:'test($,
strcat(format_date($,'yyyy')),
'Dateless')'}

[ownedbycats]

Originally Posted by dunhill

I have modified the syntax to my liking being like this.
{pubdate:'test($,
strcat(format_date($,'yyyy')),
'Dateless')'}

I liked the idea of years in the tag browser so I added this one as a custom column (though with 'unknown' instead of 'dateless').



However searching for #yearpublished:"=Unknown" just results in the search bar turning red even though there's 145 books. Did I make mistake?

[theducks]

Originally Posted by ownedbycats

I liked the idea of years in the tag browser so I added this one as a custom column (though with 'unknown' instead of 'dateless').

Attachment 182538

However searching for #yearpublished:"=Unknown" just results in the search bar turning red even though there's 145 books. Did I make mistake?

Try #yearpublished:false
I think unknown is just a visual representation for a 'not set' field value