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 ?