Emerald uses the following Query:
DateAdd(Day, 1+ma.Extension+ma.OverDue, maExpireDate)
to determine the expiration status on the account search screen.
However, it
does NOT take into consideration an expiration on the service itself
(which
could cause differing results between Emerald/RadiusNT).
RadiusNT uses something very similiar:
DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma.OverDue+1),
maExpireDate))
Which just tells how many minutes the account is still good for. The
main
difference is the clock on the SQL Server is used by RadiusNT, whereas
the clock on your local computer is used by Emerald. You might want to
check the dates of the two computers. I'll run some tests and see what
I
can come up with as well.
--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