Re: [Emerald] Expired Accounts

Dale E. Reed Jr. ( (no email) )
Sat, 19 Jun 1999 11:19:20 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: rdudek: "[Emerald] ODBC ERROR"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Feature Suggestion"
Maybe in reply to: Rick Richardson: "[Emerald] Expired Accounts"
Next in thread: Rick Richardson: "Re: [Emerald] Expired Accounts"

PowerNet wrote:
>
> Dale,
>
> I tried the query and got the error:
>
> Msg 207, Level 16, State 2
> Invalid column name 'GetDate'.
>
> Any ideas?
> >Select CustomerID, LastName, Company, maExpireDate
> >From MasterAccounts
> >Where (maExpireDate is not null AND GetDate < maExpireDate)
> > or
> > (OverLimit > 0 AND Balance > OverLimit)

Sorry GetDate should be GetDate()

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

Previous message: rdudek: "[Emerald] ODBC ERROR"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Feature Suggestion"
Maybe in reply to: Rick Richardson: "[Emerald] Expired Accounts"
Next in thread: Rick Richardson: "Re: [Emerald] Expired Accounts"