How to import date DD-MMM-YYYY Format in Nav

dipakpatel2505

Hi All,

I am having following problem:

I am importing from Excel file using Excel buffer by Code as shown below:
ExcelBuf.OpenBook(FileName,SheetName);
ExcelBuf.ReadSheet;

There is one field "Submit Date/Time" (having data in format 13-Nov-2012 10:37:54 AM EST) as shown in attached screenshot. I want to import "Submit Date/Time" value in "Document Date" field of Gen Jnl Line.

I have try to do it using Evaluate function but it gives following error:

---

Microsoft Dynamics NAV Classic

---

'13-Nov-2012 10:37:54 AM EST' is not a valid date.

---

OK

---

Any help is appriciated.

Gil

The format from the excel cant be retrieved.
Instead make a simple algorithm like this
since the date 'space' time
i would suggest get the string to chop it off till the space of the date
then convert it from that point.
you may want to try format/ or dmytodate

pitt95

It seems that there is different between Classic and RTC. In RTC, it is a DateTime type.

Classic
EVALUATE(rImportBuffer."Invoice Date", ExcelBuf."Cell Value as Text");

RTC
EVALUATE(vInvDate, ExcelBuf."Cell Value as Text");
rImportBuffer."Invoice Date" := DT2DATE(vInvDate);
(vInvDate is a datetime type)