extracting date and time fields from csv file

[Former Member]

I have date and time fields in the following format in a csv file

Date 11.12.2011

Time 00:00:02

What info objects should I extract these to at the moment I have choosen 0CALDAY (length 😎 and 0TIME (length 6) and am not getting the correct value

Thanks

[Former Member · Accepted solution]

hi,

check the following things 0calday is in format YYYYMMDD, in infoobject conversion routine should be PERI6,

also check the infoobject sequences and header columns used in csv file and 'ignore number of rows' in info package

regards,

laksh

[former_member182343]

Change your date and time format to YYYYMMDD and HHMMSS.

It doesn't allow the format you specified in th CSV file, SAP has a standard format and you are supposed to follow it.

[Former Member]

Changed the format from internal to external for the two fields

[Former Member]

Hi,

While loading data from Flat file to BI, the Date format should be like this -

Eg:

Current format in CSV file (i guess)

Date 11.12.2011 (DD:MM:YYYY)

Time 00:00:02 (HH:MM:SS)

Change format in CSV file like

Date 20111211 (YYYYMMDD)

Time 000002 (HHMMSS)

Thanks,

Peddi