BookmarkSubscribeRSS Feed
saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Keeping column data format after changing numeric to character

8800_2015-05-16_23-51-43.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

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

-Jeff
1 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

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

-Jeff