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

chachitano@hotmail.com
chachitano@hotmail.com Member Posts: 8
in NAV Three Tier
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

  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

  • chachitano@hotmail.com
    chachitano@hotmail.com Member Posts: 8
    Hector_Parada wrote: »
    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.

Categories