-----Original Message-----
From: Barry Kiesz <barry@hdc.net>
To: Emerald List <emerald@emerald.iea.com>
Date: May 11, 1998 10:06 PM
Subject: Use of the GATEDATE () in VerifyMailUsers Proc.
>We are in the process of modifying the VerifyMailUser Stored Procedure to
>deny access to expired accounts. We added the last line...
>
>--
>Select Login, Shell, EMail, d.MailDomain, Password, HomeDir
>From MasterAccounts ma, SubAccounts sa, Groups g, Domains d, AccountTypes at
>Where ma.CustomerID = sa.CustomerID
> AND ma.GroupID = g.GroupID
> AND g.DomainID = d.DomainID
> AND at.AccountType = sa.AccountType
> AND at.ExternalSystemID = @esid
> AND ( ((Login=@username OR shell=@username) AND d.Domain=@domain)
> OR Email = @username + "@" + @domain )
> AND ma.maExpireDate >= GETDATE()
>GO
>---
>
>The problem is that the users don't actually expire in Emerald until
>midnight, but in this proc. they expire at midnight the day before.. Is
>there a way to "add" a day to the GETDATE()?
>
>
>
>
>Regards,
>
>Barry
>
>--------------------------------------------
>Barry Kiesz, MIS
>barry@hdc.net
>Hard Drive Central 605-229-1562 Voice
>423 Moccasin Drive 605-229-1563 Fax
>Aberdeen,SD 57401
>--------------------------------------------
>
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>