MobileRead Forums - View Single Post - Searching by date does not consider System Locale when using ambiguous dates

tempura · 04-12-2014, 02:23 AM

I just had a little error while searching with dates in Calibre 1.32 and 1.31 on Windows 7 x86 or 32 bit. For some odd reason, the search does not consider the System locale when searching for ambiguous dates. For example I was searching for

Code:

date:10/04/14

on a dd/mm/yy or dd/mm/yyyy Locale(which I verified in my Control Panel, just in case) which does not display any result.

But when I search for:

Code:

date:10/04/13

The results displayed are for all the records containing the Date, "04 Oct 2013" thereby connoting it is using a mm/dd/yy format which is odd because, I also checked the Calibre manual just in case, I was not doing something correctly, and here's what the manual says:

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.

Side Note: I also tested searching with the code,

Code:

date:27/03/14

and

Code:

date:03/27/14

which show perfectly all the records with the Date, "27 Mar 2014".

Also searching by:

Code:

date:"10 Apr 2014"

just displays all the records with Date from "1 Jan 2014" till today i.e. "12 April 2014". Though this might quite possibly be due to wrong syntax.

So, is it that I am doing something wrong or that it's a bug?