Re: [Emerald] Expired Accounts

Dale E. Reed Jr. ( (no email) )
Mon, 21 Jun 1999 13:00:24 -0700

Rick Richardson wrote:
>
> > Select CustomerID, LastName, Company, maExpireDate
> > >From MasterAccounts
> > Where (maExpireDate is not null AND GetDate < maExpireDate)
> > or
> > (OverLimit > 0 AND Balance > OverLimit)
>
> also..I applied the query and then tried to add the extension table to
> it
> to get the current expiration date, the values are usually 30 or 60
> I assume they mean days.. the thing is I'm having no luck
> adding the integer to the date.. I'm sure it's fairly simple,
> I've just never seen it done

Select CustomerID, LastName, Company, maExpireDate