conversion of negative numbers

[vardhan354]

Hi folks,


i have a source column A of datatype numeric of length 6

and target is also numeric of length6

The logic need to be applied for this field

is when the source record value is -ve then it represents the age>80

with respect to that we need to add the Century for that value.

Please help me with any logic.

my understanding is first to convert numeric filed to DATE
then by writing logic on that date filed will work.

Thanks in advance.

[ray.wurlod]

You will probably find it easier leaving everything of data type numeric. All you need is a suitable If..Then..Else, and plain arithmetic.

[jgreve]

Please explain your logic a little more.
"when the source record value is negative, then
it represents the age > 80."

Perhaps an example would help me.
Do you mean like this?

Code: Select all

A  = B
0 = 0
1 = 1
50 = 50
79 = 79
80 = 80
81 = not possible?
-1 = 81
-19 = 99
-20 = 100

[vardhan354]

Thanks for u r response jgreve,

i will give a complete logic for that by the end of the day.


please help me.


Thanks in advance.