Jennifer, It does this because a range goes from first (earliest) to last (latest). That is true for any "between" (range) query, regardless of the data type.
Hope that helps. Regards, Mike Rylander -- Sent from my phone, please pardon my thumbs. | President | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com On Jun 30, 2016 10:22 AM, "Walz, Jennifer" <[email protected]> wrote: > Brent, > > > > Thanks! > > > > This did it. Whew. I thought maybe I was going nuts. WHY does it > do this? And can some instruction be listed someplace? > > > > Just wondering. Now to figure out how many Titles we added last year. > Ha! > > > > Jennifer > > > > *From:* Open-ils-general [mailto: > [email protected]] *On Behalf Of *Brent > Mills > *Sent:* Wednesday, June 29, 2016 7:10 PM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Help with reports - need end of year > stats - can't get data - blank report > > > > Jennifer, > > > > And there is a ‘canned’ report from Equinox that is Count Items Added by > Date Range. But nothing ever comes out. I just get a blank. I’ve > tried all kinds of date ranges and don’t know what is wrong. > > > > Have you tried putting the older date range value in the first section of > the between? I think that’s been an issue with a few of our date range > reports. > > > > > > > > -Brent > > > > ----------------------------- > > Brent Mills > Systems Librarian | Sage Library System > > email: [email protected] > tickets: https://sagesupport.eou.edu > phone: 541.610.8384 > > > > On Jun 29, 2016, at 1:47 PM, Walz, Jennifer <[email protected]> wrote: > > > > And there is a ‘canned’ report from Equinox that is Count Items Added by > Date Range. But nothing ever comes out. I just get a blank. I’ve > tried all kinds of date ranges and don’t know what is wrong. > > >
