topic Re: converting a 6 char string to date in Application Development and Automation Discussions

converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:09:42 GMT

Please help..

How can I convert a 6 char date (ddmmyy) to date format

that can be passed as input to function module?

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:12:58 GMT

yaa can .

use the concatenate statement ...

data: v_date(10) type c ,

v_test type string ,

v_data(10) .

v_test = '200801' .

v_data = v_test .

concatenate v_data '01' into v_date .

write:/ v_date using edit mask '____/__/__'.

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:14:54 GMT

concatenate '20' v_char64(2) v_char62(2) v_char6+0(2)

into v_date.

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:14:57 GMT

Hi,

Try function module 'PERIOD_AND_DATE_CONVERT_INPUT'. Note: You will need to convert your input to mmddyy format first.

Regards,

Jamie

Edited by: James Gaddis on Jul 30, 2008 10:16 AM - Added info about converting to mmddyy.

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:15:55 GMT

hi,

Use FM's

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

CONVERT_DATE_TO_INTERN_FORMAT

Regards,

Santosh

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:17:14 GMT

Hi,

Declare a variable as the type of variable in FM to which u r passing ur date.

then add 'write var1 to var2'.

Pass var2 to FM.

Regards,

Subbu

Re: converting a 6 char string to date

Former Member — Wed, 30 Jul 2008 14:20:50 GMT

Hi,

Try FM,

CONVERT_DATE_TO_INTERNAL

Run this sample code,

DATA:
  my_date(6) TYPE c VALUE '300708',
  w_date     TYPE sy-datum.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
  EXPORTING
    date_external                  = my_date
*   ACCEPT_INITIAL_DATE            = ACCEPT_INITIAL_DATE
 IMPORTING
   date_internal                  = w_date
 EXCEPTIONS
   date_external_is_invalid       = 1.
          
WRITE: w_date.

Regards

Adil

Re: converting a 6 char string to date

Former Member — Thu, 31 Jul 2008 12:19:32 GMT

Thanks to all for your help.