12417_en-US

liliconcom

Keeping column data format after changing numeric to character<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hi all,

Does anybody know how to keep the char column as fixed dec as the num column?

Please check "Missing Since [In Days]" and the "Char Days" columns

Many thanks in advance

Re: Keeping column data format after changing numeric to character

You'll need to use the Round() function before converting with the Char() function.

    Char(Round(:Missing Since, 0))

-Jeff