topic Re: Date Convertion in Application Development and Automation Discussions

Date Convertion

Former Member — Thu, 22 Mar 2007 16:43:40 GMT

Hi,

I am getting wa_input-invdt as 060719, I want this to be as 07/19/2006. Can you please help me to convert this.

Thanks

Veni.

ferry_lianto — Thu, 22 Mar 2007 16:48:06 GMT

Hi,

Please try this FM CONVERT_DATE_TO_INTERN_FORMAT.

Regards,

Ferry Lianto

Former Member — Thu, 22 Mar 2007 16:48:13 GMT

Hi!

CONCATENATE wa_input-invdt2(2) '/' wa_input-invdt4(2) '/20' wa_input-invdt(2) INTO lv_datum.

Regards

Tamá

amit_khare — Thu, 22 Mar 2007 16:51:29 GMT

check this FM -CONVERT_DATE_FORMAT

it will do the same.

Regards,

Amit

RaymondGiuseppi — Thu, 22 Mar 2007 17:01:53 GMT

Use

WRITE wa_input-invdt TO <your field>.

Before, use

SET COUNTRY f.

to choose the format and separator of the country.

Regards.

Former Member — Thu, 22 Mar 2007 17:17:38 GMT

Hi Veni,

DATA V_DATE(10).

DATA V_YEAR(4).

CONCATENATE '20' WA_INPUT-INVDT+0(2) INTO V_YEAR.

CONCATENATE WA_INPUT-INVDT2(2) WA_INPUT-INVDT4(2) V_YEAR INTO V_DATE SEPARATED BY '/'.

WRITE V_DATE.

Thanks,

Vinay