Importing Item Journal Line from Excel.

I am using the Data Migration utility in navision to import the data from excel file. I am inserting the data in Item Journal Line Table.

The issue is that when i import the data it imports every thing and shows the data fine. But it is not importing the Posting Date, Although it is there in the sheet and when i open the form and edit it is saved.

So can any one tell me what is the issue is there any validity issue or format issue of date on excel i also tried to change it to text data type on excel. But every thing is importing but posting date please help needed.

Thanks.