<i>Everything seems to import fine but the views do not display the due date </i>
If I understand your question correctly, the problem may be in the hidden <b>formatting on the DueDate column in Excel.</b> Instead of being formatted as a ‘date’ it may have a ‘custom format’ that Notes does not recognize on import as a date.
I import Excel to Lotus Notes files every day and some of the Excel files I use come from a database app written in Access where the developer used the “Format()” command on the data being exported to build the date using a text string, such as: <pre>Format(DueDate,”mm/dd/yyyy”)</pre> While that may make it look attractive to his users <i>(at least the ones in the US where they use m/d/y — I bet the Europeans have to look twice!)</i> it renders those cells in Excel with ‘custom formatting’ instead of a ‘date’ type. I have to change the format type prior to import for Notes to recognize it as a date.
<b>Try this: </b>Before your import, open the Excel file, select the DueDate column, hit ‘control-1’ to format cells, look at the ‘Numbers’ tab (first one) and change the ‘Category’ to a date (the first choice is usually okay) and save the file. Try your import again just as you described above and see if it picks up the DueDate.