topic Re: Date format in CSV file in Application Development and Automation Discussions

Date format in CSV file

Former Member — Tue, 19 May 2009 05:02:00 GMT

Hello,

I am working on loading program which downloads the application server CSV file to internal table.

In the CSV file there is a field date in the format (22/05/2008). When I move this to my internal table field date, it is truncating to '22/05/20'. How to solve this issue.

Can I load into internal table with the same format?

Please help me.

Thanks,

Shreekant

Re: Date format in CSV file

Former Member — Tue, 19 May 2009 05:04:36 GMT

Hi,

Try to get it to into char field of length 10.Date field has 8 length so it is truncating.

Regards,

Nithya

Re: Date format in CSV file

GauthamV — Tue, 19 May 2009 05:05:07 GMT

I guess you have declares it with sy-datum.

Declare like this, this if you want ' / ' in between also.

Data : date(10) type c.

Re: Date format in CSV file

former_member222860 — Tue, 19 May 2009 05:06:07 GMT

Hi,

Pl. check the declaration of the date field in your itab, say if it is dd/mm/yy

thanks\

Mahesh

Re: Date format in CSV file

Former Member — Tue, 19 May 2009 05:06:09 GMT

Hi,

u might have declared the variable type as date/sy-datum, instaed declare it as char with length 10.

After the data is moved into ur variable , then u can move it date field using " WRITE....To...' or offsets.

regards,

Naveen

Re: Date format in CSV file

Former Member — Tue, 19 May 2009 05:12:19 GMT

Hi,

Please check below code.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = v_filename_string

filetype = 'ASC'

has_field_separator = 'X'

dat_mode = 'I'

TABLES

data_tab = it_input

Re: Date format in CSV file

faisalatsap — Tue, 19 May 2009 05:16:13 GMT

Hi, Rangrej

As all Suggested assign first this date to char type filed length 10 and using following way you can assign this to type date.

Test Sample Code Bellow.

TYPES: BEGIN OF ty_test,
  cdate(10),
  date LIKE sy-datum,
  END OF ty_test.

DATA: it_test TYPE STANDARD TABLE OF ty_test WITH HEADER LINE.

it_test-cdate = '22/05/2008'. APPEND it_test.
it_test-cdate = '23/05/2008'. APPEND it_test.
it_test-cdate = '24/05/2008'. APPEND it_test.
it_test-cdate = '25/05/2008'. APPEND it_test.
it_test-cdate = '26/05/2008'. APPEND it_test.

LOOP AT it_test.
  it_test-date+0(4) = it_test-cdate+6(4).
  it_test-date+4(2) = it_test-cdate+3(2).
  it_test-date+6(2) = it_test-cdate+0(2).
  MODIFY it_test INDEX sy-tabix.
ENDLOOP.

Best Regards,

Faisal