C# and NAV not use the same date format?

julkifli33 · 2012-01-09

hi all
i create codeunit in nav
and it works to import
i'm using web service to access nav from C#
but when i import data (for date type), it tells me '23/12/2011' is not a valid date.
i use the same pc but the date i think from C# itself using MMDDYYYY
how to solve this?

julkifli33 · 2012-01-09

my code in codeunit like this

    PostingDateText := FORMAT(COPYSTR(vString,1,PosCode-1));
    EVALUATE(PostingDate,PostingDateText);
    SH."Posting Date" := PostingDate;

is there something wrong?

kine · 2012-01-09

Depends on how you are passing the date. If you are using paramter of type date, it will work ok. If you are passing it as text, than you need to parse the xml format correctly.

Sog · 2012-01-09

There is a build-in function to parse xml-formatted dates.

mdPartnerNL · 2012-01-09

This one? viewtopic.php?f=23&t=51130&hilit=evaluate

julkifli33 · 2012-01-09

kine wrote:

Depends on how you are passing the date. If you are using paramter of type date, it will work ok. If you are passing it as text, than you need to parse the xml format correctly.

actually postingdate here is variable as date type

julkifli33 · 2012-01-09

mdPartnerNL wrote:

This one? viewtopic.php?f=23&t=51130&hilit=evaluate

i used this method for posting date, and it works
i thought there is another method to solve this issue
anyway, i use this first

Howdy, Stranger!

Quick Links

Categories

C# and NAV not use the same date format?

Comments