How to format pubdate so I only get year in the catalog output please?

[millan]

How to format pubdate so I only get year in the catalog output please?

not like:

PHP Code:

'2014-03-04T00:00:00+02:00
'2003-05-13T00:00:00+03:00 


I want just :
2014
2003
etc

Thank you in advance

[BetterRed]

From ===>>> The calibre template language — Using functions in templates

{pubdate:format_date(yyyy)}

BR

[millan]

Originally Posted by BetterRed

From ===>>> The calibre template language — Using functions in templates

{pubdate:format_date(yyyy)}

BR

Thank you for your prompt reply, BetterRed

I don't even know where to start.

The page link has 19 page of info and doesn't tell me where the editing template is, if there's one

Would you please tell me step by step how to get to functions in templates such as:

1) Go to "Preferences"
2) do this in "change calibre behavior"
3) do that in "import/export"

[theducks]

By 'Catalog output' you mean the one created using the right click option on the conversion icon?

or do you mean 'On the Spreadsheet' view? Preferences: Tweaks: (it is one of the Date format tweaks

[millan]

Originally Posted by theducks

By 'Catalog output' you mean the one created using the right click option on the conversion icon?

or do you mean 'On the Spreadsheet' view? Preferences: Tweaks: (it is one of the Date format tweaks

on the Spreadsheet output, I get long pubdate like:

'2014-03-04T00:00:00+02:00
'2003-05-13T00:00:00+03:00

and I'd like to have like:

2014
2003

since I have more than few hundred book/articles list and growing every so often which also means I update the catalog output so often, I need a permanent solution if possible in the output file which I then save .xls as html and search the contents via that html file

[theducks]

Originally Posted by millan

on the Spreadsheet output, I get long pubdate like:

'2014-03-04T00:00:00+02:00
'2003-05-13T00:00:00+03:00

and I'd like to have like:

2014
2003

since I have more than few hundred book/articles list and growing every so often which also means I update the catalog output so often, I need a permanent solution if possible in the output file which I then save .xls as html and search the contents via that html file

you must be using the CSV output of the Catalog out.
That is a 'timestamp' format

You will probably have to clean it up using the substring function of your spreadsheet.

[millan]

Originally Posted by theducks

you must be using the CSV output of the Catalog out.
That is a 'timestamp' format

You will probably have to clean it up using the substring function of your spreadsheet.

There are hundreds of hundreds lines "to be cleaned"

I'm trying to avoid that.

Any other options like editing the output template or something please?

[chaley]

Create a new custom column "built from other columns" (not like tags). Set the template for that column to what BetterRed suggested:

{pubdate:format_date(yyyy)}

Then export that column instead of pubdate

[BetterRed]

@millan - chaley beat me to it

But my bad I should have deduced you were referring to a CSV catalogue

BR

[millan]

Thank you all again.
I think I'll be able to start doing it.
Would you please tell me how to get to the interface for the below point please:

Create a new custom column "built from other columns"

[BetterRed]

Originally Posted by millan

Thank you all again.
I think I'll be able to start doing it.
Would you please tell me how to get to the interface for the below point please:

Create a new custom column "built from other columns"

@millan - see attachment

BR

[millan]

Originally Posted by BetterRed

@millan - see attachment

BR

Thank you the perfect visual, BetterRed

All the best from an ex Sydney, NSW Resident

[millan]

It was working Ok.
I have checked it today
some of the items under Year Published Column comes up as "BAD DATE" as shown below.

Any solution please?

[BetterRed]

@millan - could you put the database published date into the book list alongside your Year Published - right click column headings and select Show Column->Published, and post a screen shot showing both.

Also have a look at the Published Date in Metadata edit for one of those BAD DATE's

I suspect the Year Published template needs to be adjusted to cope with undefined dates or something like that

BR

[millan]

Thank you for your prompt response BetterRed

I added the published date into the book list alongside my Year Published -

had a look at the Published Date in Metadata changed the days of the month for one of those BAD DATE's

I have even deleted the Year Published column and recreated again

Do you think it might be something to do with my installation of the Calibre's new update I have installed today?

posting the screen shot showing both