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. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com