topic searching for corect data element in Application Development and Automation Discussions

searching for corect data element

Former Member — Mon, 28 Dec 2009 08:15:52 GMT

Hello,

I would like to calculate beetween two coloumns and I don't find corect data element. The field which be calculated are dates (delivery date - posting GR date). I have choosen the data type NUMC_5, but this data type is also positive. I would like to have - (minus) if the gr is before the delivery date.

Which data element should I choose?

Saso

Re: searching for corect data element

Former Member — Mon, 28 Dec 2009 08:21:47 GMT

Try using floating point numbers

Re: searching for corect data element

Former Member — Mon, 28 Dec 2009 08:23:59 GMT

Hi Saso Poljansek,

There is no dataelement with Sign

You can achieve it as below.. multiply the value by -1 (Negative 1) based on condition. so the value becomes negative

if gr_date < delivery_date.

diff = delivery_date - gr_date.

diff = diff * -1 .

else.

diff = gr_date - delivery_date .

endif.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya