search by born date?

[Lauraq]

Hi
I have add a column named "born" and I have enter the born date of my author, for example 1920 or 1946 or 1790
Now I want to create a virtual library search for every hundred years, so, for example, if I create a virtual library of 1900 in the results I have all authors born during that time, as in 1920 or 1946.
So I created a virtual library with this command:

#born: "= 19"

but I do not know what is the wildcard to search for all numbers after 19

[eschwartz]

Use the "~" to activate regular expression mode in searches.

#born:"~^19"

Searches for "begins-with-19"

[BetterRed]

@Lauraq - why not enter author year of birth as an integer - and set up VL's thusly:

21st Century - #born:">2000"
20th Century - #born:">1899" and #born:"<2001"
19th Century - #born:">1799" and #born:"<1901"
...

BR

[eschwartz]

regex is more fun.

[Lauraq]

Originally Posted by eschwartz

Use the "~" to activate regular expression mode in searches.

#born:"~^19"

Searches for "begins-with-19"

#born:"~^19"

don't work for me "the search in the search box is not valid"

[Lauraq]

Originally Posted by BetterRed

@Lauraq - why not enter author year of birth as an integer - and set up VL's thusly:

21st Century - #born>2000, 
20th Century - #born>1899 and #born<2001
19th Century - #born>1799 and #born<1901
...

Not tested

BR

can you tell me exactly what I must do? I m not expert, for now I have only enter the born year in all my author

[theducks]

There is a whole section devoted to Searching.
http://manual.calibre-ebook.com/gui.html#search-sort
Dates being a section a short scroll down (there are no finer links/anchors)

[Lauraq]

Originally Posted by theducks

There is a hole section devoted to Searching.
http://manual.calibre-ebook.com/gui.html#search-sort
Dates being a section a short scroll down (there are no finer links/anchors)

I never thought to find a guide on the program website

[theducks]

Originally Posted by Lauraq

I never thought to find a guide on the program website

That is the WHOLE manual as it changes almost weekly in some small ways as new features pop out.

There is also a FAQ that I wish was required reading. It would avoid many recoveries

[Lauraq]

Originally Posted by theducks

That is the WHOLE manual as it changes almost weekly in some small ways as new features pop out.

There is also a FAQ that I wish was required reading. It would avoid many recoveries

is ironic my post

if I ask for help here I am because I have not found a solution by reading (in my bad English) the various guides that I found

[BetterRed]

Originally Posted by Lauraq

can you tell me exactly what I must do? I m not expert, for now I have only enter the born year in all my author

Create a custom column like this



I suggest you don't use a Date column. Calibre doesn't seem to handle dates earlier that 1st Jan 101 properly, also you could get tangled up in timezones. Using a string representation will make it awkward to deal with authors like Homer, Herodotus etc etc

If you can select all books for an author, you can use bulk edit to change the born year in those books

Pity Authors can't have custom columns

BR

[Lauraq]

Originally Posted by BetterRed

Create a custom column like this

Attachment 138403

I suggest you don't use a Date column. Calibre doesn't seem to handle dates earlier that 1st Jan 101 properly, also you could get tangled up in timezones. Using a string representation will make it awkward to deal with authors like Homer, Herodotus etc etc

If you can select all books for an author, you can use bulk edit to change the born year in those books

Pity Authors can't have custom columns

BR

Thanks

Ok I have create the column like your image, but now what I must enter in the virtual library?

[eschwartz]

Originally Posted by Lauraq

#born:"~^19"

don't work for me "the search in the search box is not valid"

Works for me.

What type of column is it?

[BetterRed]

Originally Posted by Lauraq

Thanks

Ok I have create the column like your image, but now what I must enter in the virtual library?

Enter the Born Years for some Authors, and then set up your VL's thusly




Tested this time - previous post had conceptual search terms. the above are the real-deal

BR

[Lauraq]

Originally Posted by BetterRed

Enter the Born Years for some Authors, and then set up your VL's thusly

Attachment 138404
Attachment 138405

Tested this time - previous post had conceptual search terms. the above are the real-deal

BR

unfortunately I'm moving books from one store to another and I can't try if they work, check tomorrow and let you know. But I do not know if you understand what I want. I want an entry for every 100 years in the virtual library

1500
1600
1700
etc etc

and if I click on 1500 they must appear all authors born 1500-1599