Dateformula from SQL

ara3n

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.

FDickschat

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

kine

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.