[Emerald] Searching for invoices

Josh Hillman ( (no email) )
Sun, 16 May 1999 21:19:50 -0400

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