Regarding converting character value into date value

[former_member330379]

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]

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

[former_member330379]

Dear umang,

Done

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

Regards

sky

[Former Member]

Hi Sky,

You can <removed by moderator> close the thread.

Regards,

Umang Mehta

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

[raymond_giuseppi]

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