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