Hi,



How do I get the max invoice date less than the current invoice date in the
dataset row the server is processing ie:-



select max (hrsworked.invoicedate)

from hrsworked

where hrsworked.forkliftoid = :ForkliftOID and

hrsworked.invoicedate < �the current invoicedate the sql server is
currently processing�



Thanks,

Dion.


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 17/05/2006



[Non-text portions of this message have been removed]