Searching future dates

diazlaz · 02-02-2014, 02:47 PM

Hi all,

Im interested in limiting the search of date field 2 months into the future such as date:<2013-04-02, is there a specific formula or keyword I can apply to make this more dynamic such as show me all books 2months from the current date rather than hardcoding date in the search.

Many thanks in advance!

eschwartz · 02-02-2014, 02:59 PM

From the manual:

Quote:

If the date is ambiguous, the current locale is used for date comparison. For example, in an mm/dd/yyyy locale 2/1/2009 is interpreted as 1 Feb 2009. In a dd/mm/yyyy locale it is interpreted as 2 Jan 2009. Some special date strings are available. The string "today" translates to today’s date, whatever it is. The strings "yesterday" and "thismonth" (or the translated equivalent in the current language) also work. In addition, the string "daysago" (also translated) can be used to compare to a date some number of days ago. For example:

Code:

date:>10daysago
date:<=45daysago

diazlaz · 02-02-2014, 08:28 PM

thanks eschwartz - I was not enable to limit it to a date in the future and return all the results prior to the date limit. if I specify a date it works date:<2013-04-01.

eschwartz · 02-02-2014, 08:30 PM

so it worked?

theducks · 02-02-2014, 08:56 PM

Quote:

Originally Posted by diazlaz

thanks eschwartz - I was not enable to limit it to a date in the future and return all the results prior to the date limit. if I specify a date it works date:<2013-04-01.

You need to set a And condition published:>date and published:<date

DoctorOhh · 02-02-2014, 10:08 PM

I'm confused by your examples, since it is 2014 not 2013.

theducks · 02-02-2014, 10:39 PM

Quote:

Originally Posted by DoctorOhh

I'm confused by your examples, since it is 2014 not 2013.

Back to the Future ???

BetterRed · 02-02-2014, 10:59 PM

@diazlaz So in utopia you would write something like

Code:

#my_date:"< (today + 2 months)"

I'm pretty sure that's invalid, and I'm not sure that the template language supports date arithmetic - couldn't see it, but I get lost in that section of the manual so...

BR

kovidgoyal · 02-02-2014, 11:04 PM

date:>today and date:<-60daysago

eschwartz · 02-02-2014, 11:05 PM

Try this:

Code:

date:<-60daysago

It's the formula already given, I am assuming it will take negative numbers as well. Seems a fair assumption.

02-02-2014, 02:47 PM	#1
diazlaz Member Posts: 15 Karma: 10 Join Date: Dec 2003 Device: Toshiba E755	Searching future dates Hi all, Im interested in limiting the search of date field 2 months into the future such as date:<2013-04-02, is there a specific formula or keyword I can apply to make this more dynamic such as show me all books 2months from the current date rather than hardcoding date in the search. Many thanks in advance!

02-02-2014, 10:59 PM	#8
BetterRed null operator (he/him) Posts: 22,010 Karma: 30277294 Join Date: Mar 2012 Location: Sydney Australia Device: none	@diazlaz So in utopia you would write something like Code: #my_date:"< (today + 2 months)" I'm pretty sure that's invalid, and I'm not sure that the template language supports date arithmetic - couldn't see it, but I get lost in that section of the manual so... BR

02-02-2014, 11:05 PM	#10
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Try this: Code: date:<-60daysago It's the formula already given, I am assuming it will take negative numbers as well. Seems a fair assumption.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to get your Kobo to use non-US dates	GeoffR	Kobo Reader	167	10-11-2021 07:34 AM
Dates in Calibre	the_callant	Library Management	6	12-01-2013 03:50 PM
Published - Dates	bigbird1227	Plugins	4	08-21-2011 06:54 AM
Published Dates	bigbird1227	Library Management	7	06-10-2011 10:40 AM
Dates in Russian (?)	Roger Wilmut	Calibre	10	11-24-2008 06:22 PM

02-02-2014, 08:28 PM	#3
diazlaz Member Posts: 15 Karma: 10 Join Date: Dec 2003 Device: Toshiba E755	thanks eschwartz - I was not enable to limit it to a date in the future and return all the results prior to the date limit. if I specify a date it works date:<2013-04-01.

02-02-2014, 08:30 PM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	so it worked?

02-02-2014, 10:08 PM	#6
DoctorOhh US Navy, Retired Posts: 9,897 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen	I'm confused by your examples, since it is 2014 not 2013.

02-02-2014, 11:04 PM	#9
kovidgoyal creator of calibre Posts: 45,604 Karma: 28548974 Join Date: Oct 2006 Location: Mumbai, India Device: Various	date:>today and date:<-60daysago

Advert

Advert