[OPEN-ILS-GENERAL] Assistance needed with a report

[Catherine Buck Morgan]

I did it. I need to know the total number of registered patrons on the last day of the month. I ended up filtering this: ILS User ---> User Demographics ---> Record Creation Date/Time, with a field transform of Year+Month and an Operator of On or Before (Date/Time). 

When I compared the data between Aug and Sept, I came up with a difference of 79, which is the number of new users added in Sept. 

Thanks,
Catherine.   

-----Original Message-----
From: Sharp, Chris [mailto:csharp at georgialibraries.org] 
Sent: Monday, October 12, 2009 4:06 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Assistance needed with a report

Hi Catherine,

Would it be patrons who used the library (checked out, placed a hold, etc) on a specific date?  Or patrons who were created on a specific date?  What is the importance of the date in your report?  Dates in Evergreen are almost always tied to actions.

Chris

Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/

----- "Catherine Buck Morgan" <Cmorgan at statelibrary.sc.gov> wrote:

> I ’ m trying to create a report that will give me the number of users
> by patron type * for a specific date * . That last one is stumping me.
> I can ’ t figure out how to get a timestamp for say, Sept. 30. My
> source is ILS User.
> 
> Any assistance would be appreciated. (We ’ re on Evergreen 1.4.0.6)
> 
> Thanks,
> 
> Catherine.
> 
> 
> 
> --
> 
> Catherine Buck Morgan
> 
> Director, Division of Innovation, Technology & Library Services
> 
> South Carolina State Library
> 
> POB 11469, 1500 Senate Street, Columbia , SC 29211
> 
> Phone: 803.734.8651 | Cell: 803.239.8363 | Fax: 803.734.4757
> 
> cmorgan at statelibrary.sc.gov www.statelibrary.sc.gov
> 
> The South Carolina State Library is a national model for innovation,
> collaboration, leadership and effectiveness. It is the keystone in
> South Carolina ’ s intellectual landscape.