date field

[iomari]

greetings,

is there some hidden field that stores the date a book was entered into the database? I would like to bring that out to the front end.

[iomari]

nevermind. I've seen the timestamp field in the database. :-)

[iomari]

Can someone give me a hint how to add the timestamp field as a custom column?
I can't seem to find the right function to use for the template.

[DoctorOhh]

Originally Posted by iomari

is there some hidden field that stores the date a book was entered into the database? I would like to bring that out to the front end.

I believe the Date column is the date the book was entered into the calibre database.

[iomari]

Originally Posted by dwanthny

I believe the Date column is the date the book was entered into the calibre database.

I'm embarrassed.

thanks

[chaley]

Originally Posted by iomari

Can someone give me a hint how to add the timestamp field as a custom column?
I can't seem to find the right function to use for the template.

Use {timestamp}. No function is necessary.

If you want to format it, then use {timestamp:'format_date($, 'yyyy')'} where 'yyyy' is replaced with the format you wish. If you want the full ISO timestamp including the time, use {:'raw_field('timestamp')'}

[iomari]

Originally Posted by chaley

Use {timestamp}. No function is necessary.

If you want to format it, then use {timestamp:'format_date($, 'yyyy')'} where 'yyyy' is replaced with the format you wish. If you want the full ISO timestamp including the time, use {;'raw_field('timestamp')'}

cool

[cybmole]

Originally Posted by dwanthny

I believe the Date column is the date the book was entered into the calibre database.

Hmm - not always, I imported a collection of "found" books" that appear to have come from a calibre collection ( because of how the book folders are structured)

I did this via Add books

they have may/June dates in my calibre library, even though I added them yesterday ???

[DoctorOhh]

Originally Posted by cybmole

Hmm - not always, I imported a collection of "found" books" that appear to have come from a calibre collection ( because of how the book folders are structured)

I did this via Add books

they have may/June dates in my calibre library, even though I added them yesterday ???

That is due to the fact that they were added to calibre in may/june and the metadata.opf files that were lying around the same folders as the books were used to add then to your library.

If this date bothers you then you have a few of options:

1. Stop adding "found" books to your library.
2. Delete the metadata.opf files prior to adding the books. The metadata.opf file is for calibre use only and is used to restore books to the library after being saved to disk or used to restore a corrupt metadata.db in the calibre library.
3. If you know that the date is not going to reflect your library you can do a bulk metadata edit after adding the books and change the date to reflect the date you added them to your library.
4. Add the books one at a time via drag and drop from the file manager to the calibre library.

Bottom line is the date column is the date when the books were added to a calibre library, if you add books from someone else' library, with the data from that library, of course the date is going to reflect when they were added to that other person's library.