You would have to add something like:
and DatePart(Day, BilledThru) = DatePart(Day, GetDate())
and then change the proc to run daily. However, one problem I see with
that is people expiring on say the 31, and during the month of February,
not getting reset.
> Marcus
>
> > marcus@redcentre.com wrote:
> > >
> > > We have an account that is intended to cut out if a specified number
> > > of hours is used within a one month period. At the start each month
> > > the number of available hours is restored.
> > >
> > > Would the following settings achieve this end. That is 10 hours per
> > > month - disconnect after time is used.
> > >
> > > Standard time: 10
> > > Standard Interval: 3600
> > > standard charge: 0
> > >
> > > Allow Overtime: not selected.
> >
> > No. Usage rates have no affect on time restrictions. What you
> > want is the TimeLeft field (maybe in conjunction with the usage
> > settings).
> >
> > Check out this URL for a FAQ/detail on how to setup recurring time
> > limit accounts.
> >
> > http://www.iea-software.com/emerald/faqs/limited-time.html
> >
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart