Re: Consolidation Question

Dale E. Reed Jr. ( (no email) )
Wed, 25 Feb 1998 15:29:03 -0800

Nylis G. Renschler II wrote:
> I am using Emerald 2.2.23. I dropped and reinstalled the Consolidation/Delete Procedures in the DB as per Dale, and you guessed it still does not perform according to what I expected!
> The calls are consolidated from 1 Jan -> 31 Jan instead of from Ma.Expiredate -> Ma.Expiredate-30 days. Am I wrong in my assumption here that it should consolidate on the Anniversary dates? Thats what I need it to do!

What Consolidation Proc did you replace it with, though? If you look
at the proc, it should be based on a DateDiff() of maExpireDate, which
is the Anniversary you are talking about.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |