Recent content by ianjdudley

I'm trying to run a simple comparison of dates in a DTS script on SQL Server 7 pulling in date from a Progress database. The code I am trying to run is: SELECT * FROM IRECOF WHERE TIMESTAMPDIFF(SQL_TSI_DAY, CURRENT_DATE, IRDTTR) <= 2 (IRDTTR is a transaction date field in the Table IRECOF...