SUBSTR Substring is only allowed on strings. You have to convert your
numeric to a string befors using substr: SUBSTR(DIGITS(IDDOCD),1,6).
The result is a string.
Am 28.02.2014 15:25, schrieb Hoteltravelfundotcom:
HI I am getting an error when i try to make substring. The date we have is
8 pos. yyyymmdd
i need to sort according to month. I get this error "SUBSTR value is not
allowed. " this is because it is numeric and it's not allowed to substr
YYYYMM SUBSTR(IDDOCD,1,6) 06
Field Text Len
IDORDT ORDER TYPE 3
IDDOCD DOCUMENT DATE 8