Hello, I have the following functional SQL statement that I need converted over to Informix syntax.. thanks for the help!

select ar_invoice_nbr from ar_item where ar_invoice_nbr in (select ih_nbr from si_invoice where ih_date > dateadd(year, -2,getdate()))

All this is doing is selecting invoice line items from invoices over the past 2 years.

Try this -

where ih_date > (current - 2 units year)