Re: [Emerald] need sql qry to find expired accounts

Dale E. Reed Jr. ( (no email) )
Wed, 28 Apr 1999 15:06:58 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: : "[Emerald] need sql qry to find expired accounts"
Next message: Ken Sorenson: "[Emerald] Mailsite/VOPmail stored procedures"
Maybe in reply to: : "[Emerald] need sql qry to find expired accounts"

> "(Ken)" wrote:
>
> need an sql query to find all accounts that expired 2 months ago.
> when i use the maaccountexp field from master accouts it isnot right
> for some reason...

If you are using Balance Forward, then there isn't an expire date
on the account. Otherwise this should work:

Select CustomerID, FirstName, LastName

Previous message: : "[Emerald] need sql qry to find expired accounts"
Next message: Ken Sorenson: "[Emerald] Mailsite/VOPmail stored procedures"
Maybe in reply to: : "[Emerald] need sql qry to find expired accounts"