Date Functions for ODBC and 9.1D?

earthbased

New Member
Hi,

I am using ODBC to access a 9.1D database. Is there equivalent SQL for Progress for this SQL Server SQL:

(Invoicedate > = dateadd (m, -3, convert (char(6), getdate(), 112) + '01')
AND (Invoicedate < convert (char (6), getdate(), 112) + '01'))

Thanks,
Dan
 
Back
Top