Proprietary Database - handling dates in ODBC

We are using Navision Financials 2.6 and I’m connecting to the database with the ODBC from SQL Server. My problem is, any dates that are empty in Navision, show up as 1/1/1753 in SQL Server. While I want to transfer the data to SQL using the DTS, I want to enter null into the destination date where Navision Date is 1/1/1753 but I can’t get the syntax. Ideally I could use IIF but it doesn’t like it. Any idea of the syntax fo this? In other words IIF(navisiontable.date = ‘1/1/1753’, null, navisiontable.date) Thanks

What is the reult you get from the IIF statement ? always null or always Navision Date ?