topic Convert Integer to date data type using query formula in Application Development and Automation Discussions

Convert Integer to date data type using query formula

Former Member — Wed, 01 Jul 2009 14:04:49 GMT

Hoi,

I want to know if there is possibility to convert an integer data type in this format (yyyymmdd) to an appropriate date data type also in the same format : yyyymmdd.

i want to use it within formula in my infoset query.

You help will be appreciated.

Thanks in advance.

Nabil.

Re: Convert Integer to date data type using query formula

former_member998879 — Wed, 01 Jul 2009 15:15:45 GMT

Hi Nabil,

try this FM: CONVERSION_EXIT_ALPHA_INPUT

is useful for convert different data type, here an example:

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = A ( type integer )

importing

output = B ( type 'data' ).

Perhaps that helps,

Regards,

Davide