I tried the query and got the error:
Msg 207, Level 16, State 2
Invalid column name 'GetDate'.
Any ideas?
*********** REPLY SEPARATOR ***********
On 6/18/99, at 11:51 AM, Dale E. Reed Jr. wrote:
>Rick Richardson wrote:
>>
>> can someone explain to me how to
>> query for expired and inactive accounts?
>> I'm in the process of creating VAR pages
>> that will recieve limited info on acconts
>> like expires and overdues.
>> But I can't get my query to spit out the
>> correct data
>
>Select CustomerID, LastName, Company, maExpireDate
>From MasterAccounts
>Where (maExpireDate is not null AND GetDate < maExpireDate)
> or
> (OverLimit > 0 AND Balance > OverLimit)
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com