topic Re: data format problem in Application Development and Automation Discussions

data format problem

Former Member — Thu, 05 Jul 2007 05:22:24 GMT

Hi,

I have one filed with date format its values is like ' 20071025'.

i want this filed value as '25/10/2007'.

how to get this format.

( any function module or any command please tell me immediately )

thanks in advance.

Kumar A.

Re: data format problem

Former Member — Thu, 05 Jul 2007 05:26:58 GMT

Hi !

Try

WRITE datevar USING DD/MM/YYY

Regards

rainer

Some points would be nice if that helped a bit.

Re: data format problem

Former Member — Thu, 05 Jul 2007 05:29:01 GMT

Hi Phani,

U can use write statement for this.

Write var1 to var2 dd/mm/yyyy.

Hope this will work.

Re: data format problem

Former Member — Thu, 05 Jul 2007 05:31:32 GMT

Hi,

check this CONVERT_dATE_TO_EXTERNAL

try this code..

DATA: V_INPUT(10) VALUE '2006/01/31'.

DATA: V_OUTPUT(10).

CONCATENATE V_INPUT5(2) V_INPUT8(2) V_INPUT(4) INTO V_OUTPUT.

WRITE: / V_OUTPUT.

<b>Reward points</b>

Regards

Re: data format problem

Former Member — Thu, 05 Jul 2007 05:32:09 GMT

Hello,

Assuming your value is in field_value.

Try this and reward if found helpfull.

Rakesh


        wrk_year  =  field_value+0(4).
        wrk_mon   = field_value+4(2).
        wrk_day   =  field_value+6(2).

        CONCATENATE  wrk_day  '/'
                                  wrk_mon '/'
                                  wrk_year
                                   INTO     wrk_date.

Re: data format problem

Former Member — Thu, 05 Jul 2007 06:18:31 GMT

Hi Phani,

try like this...

data:wa_year(4),

wa_mon(2),

wa_day(2),

wa_data(10),

f1_value type d value '20071025'.

wa_year = f1_value+0(4).

wa_mon = f1_value+4(2).

wa_day = f1_value+6(2).

CONCATENATE wa_day '/'

wa_mon '/'

wa_year

INTO wa_date.

Reward if helpful...

Re: data format problem

Former Member — Thu, 05 Jul 2007 06:35:49 GMT

here is the example

REPORT  zdate                        .

DATA: l_code  LIKE  sy-subrc.
DATA: lv_date(10) TYPE c.
DATA: BEGIN OF lwa_date OCCURS 0,
      lv_d(2) TYPE c VALUE '1',
      END OF lwa_date.

PARAMETER: p_month LIKE isellist-month.
PARAMETER: p_date(2) TYPE c.

AT SELECTION-SCREEN.

INITIALIZATION.
  DO 31 TIMES.
    APPEND lwa_date TO lwa_date.
    lwa_date-lv_d = lwa_date-lv_d + 1.
    WRITE lwa_date-lv_d.
  ENDDO.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_month.

  CALL FUNCTION 'POPUP_TO_SELECT_MONTH'
    EXPORTING
      actual_month               = '200505'
      language                   = sy-langu
      start_column               = 8
      start_row                  = 5
    IMPORTING
      selected_month             = p_month
      return_code                = l_code
    EXCEPTIONS
      factory_calendar_not_found = 1
      holiday_calendar_not_found = 2
      month_not_found            = 3
      OTHERS                     = 4.




AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_date.

  CHECK NOT lwa_date[] IS INITIAL.
  CALL FUNCTION 'POPUP_WITH_TABLE'
    EXPORTING
      endpos_col   = 5
      endpos_row   = 10
      startpos_col = 2
      startpos_row = 1
      titletext    = 'DATE'
    IMPORTING
      choice       = lwa_date
    TABLES
      valuetab     = lwa_date
    EXCEPTIONS
      break_off    = 1
      OTHERS       = 2.
  p_date = lwa_date-lv_d.


END-OF-SELECTION.
  CONCATENATE    p_date '/' p_month+4(2) '/' p_month+0(4) INTO lv_date.
  WRITE:/ 'IN DD/MM/YYYY', lv_date.
  CONCATENATE p_month+4(2) '/' p_date '/' p_month+0(4) INTO lv_date.
  WRITE:/ 'IN MM/DD/YYYY', lv_date.
  CONCATENATE  p_month+0(4) '/' p_month+4(2) '/' p_date INTO lv_date.
  WRITE:/ 'IN YYYY/MM/DD', lv_date.
*end of program.

reward points if it sis usefull ...

Girish

Re: data format problem

Former Member — Thu, 05 Jul 2007 06:49:39 GMT

Use any of these FM and passd the date to it

CONVERSION_EXIT_ALPHA_OUTPUT

CONVERSION_EXIT_IDATE_OUTPUT

CONVERSION_EXIT_LDATE_OUTPUT

CONVERSION_EXIT_SDATE_OUTPUT

CONVERSION_EXIT_PDATE_OUTPUT

CONVERSION_EXIT_DATEX_OUTPUT

regards

Shiva