How to define a data format for a date like '5012016' in Posting Exchange Definitions?

Hi,

I need to import a csv using the posting exchange definitions for a Bank Statement. I've been trying dMMyyyy, dmmyyyy, etc. (and with different formatting cultures), but none of them seems to work.
I can make it work for dates like '5/01/2016', but something is broken when it doesn't have '/' as guidance.
Have anyone found this issue before?

Regards,

HP

Answers

  • krikikriki Member, Moderator Posts: 9,112
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Hi,

    I need to import a csv using the posting exchange definitions for a Bank Statement. I've been trying dMMyyyy, dmmyyyy, etc. (and with different formatting cultures), but none of them seems to work.
    I can make it work for dates like '5/01/2016', but something is broken when it doesn't have '/' as guidance.
    Have anyone found this issue before?

    Regards,

    HP

    Finally we were able to get the file from the Bank with the slash '/' separator. I was able to import the csv, but don't have answer for the above.
Sign In or Register to comment.