Dateformula from SQL

ara3n
ara3n Member Posts: 9,258
edited 2012-08-29 in NAV/Navision Classic Client
Anybody has queried a dateformula from sql? it's not the usual 1M or 1Y instead it's other non ascii character. I was wondering if anybody knows the reason.

Thanks.
Ahmed Rashed Amini
Independent Consultant/Developer


blog: https://dynamicsuser.net/nav/b/ara3n

Comments

  • FDickschat
    FDickschat Member Posts: 380
    The reason must be multi language capability. 1Y is 1J in German or 1A in French. That's why we always program <1Y> and not directly 1Y.
    Yes, they could have used the english letters in SQL and let the client convert it. I think we have to ask them at Techdays why they decided on these strange ASCII values. 
    Date
Formula  Char
  L       01
  D       02
  WD      03
  W       04
  M       05
  Q       06
  Y       07
    Frank Dickschat
    FD Consulting
  • kine
    kine Member Posts: 12,562
    There was already thread about this few years ago and I think in it it is a function you can use to convert the ASCII chars 01..07 to readable characters.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories