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

dipakpatel2505
dipakpatel2505 Member Posts: 169
edited 2012-12-07 in NAV/Navision Classic Client
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.

Comments

  • Gil
    Gil Member Posts: 49
    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
    pitt95 Member Posts: 8
    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)

Categories