Re: [Emerald] Searching for invoices

Dale E. Reed Jr. ( (no email) )
Sun, 16 May 1999 19:38:41 -0700

Josh Hillman wrote:
>
> Suggestion for Emerald 2.5:
> Ability to search for invoices based on Invoice.Date (while not being
> specific to the time of day). In other words:
>
> SELECT InvoiceID, Date, Type, Amount, Company,
> Name=(FirstName+' '+LastName)
> FROM Invoices i, MasterAccounts ma
> WHERE i.CustomerID = ma.CustomerID
> AND DateDiff(Day, Date, '5/16/99') = 0
>
> Josh

What would you use this for?

-- 

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