topic Re: Regarding converting character value into date value in Application Development and Automation Discussions

Regarding converting character value into date value

former_member330379 — Mon, 13 Jun 2011 11:24:23 GMT

HI all,

i the table J_1IASSVAL - Assessable value table for excise calculation , in J_1IFRDATE field, date is stored but in my

system it is stored in character form i.e. in the form of ' 79918898' .

now i want to convert this character form value into Date form value

is there any function module exist for converting character value into date value

Regards

sky

Former Member — Mon, 13 Jun 2011 11:34:52 GMT

Hi,

There is a conversion routine INVDT.

Use function module CONVERSION_EXIT_INVDT_OUTPUT and enter the value 79918898 as an input will give you date as an output.

Please check and confirm.

Regards,

Umang Mehta

RaymondGiuseppi — Mon, 13 Jun 2011 11:44:46 GMT

Subtract your value from 99999999 you will get a date in DATS internal format (eg. 99999999 - 79918898 = 20081101)

datefield = '99999999' - J_1IASSVAL-J_1IFRDATE.

This format purpose is to sort data by date descending.

Regards,

Raymond

former_member330379 — Mon, 13 Jun 2011 11:45:18 GMT

Dear umang,

Done

Thanks a lot .............

Regards

sky

Former Member — Mon, 13 Jun 2011 12:05:05 GMT

Hi Sky,

You can <removed by moderator> close the thread.

Regards,

Umang Mehta

Edited by: Vinod Kumar on Jun 13, 2011 5:36 PM