[Koha-bugs] [Bug 12452] check susbscription expiration doesn't work

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12452

Jonathan Druart <jonathan.druart at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at biblibre.co
                   |                            |m

--- Comment #2 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(In reply to Katrin Fischer from bug 8436 comment #13)
> Julian, could you take a look at the search for the expiration date? I think
> I can see bug 12452. 
> 
> I have a serial subscription with expiration date on 10/09/2014.
> If I use the filter on the left side of the subscription search with
> 01/10/2014 the subscription shows up (as it should).
> 
> But when I repeat the same search on the 'check expiration' page, the
> subscription is not found.
> 
> Using iso formatted dates dd/mm/yyyy.

Looks good here.

- formatdate is dd/mm/yyyy

- MariaDB [koha]> select enddate from subscription where subscriptionid=6\G
*************************** 1. row ***************************
enddate: 2016-07-01

- go on serials/checkexpiration.pl

- Expiring before: 01/08/2016

I got "1 subscription(s) will expire before 01/08/2016"

What I did wrong?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.