Skip to Content
author's profile photo Former Member
Former Member

Error while loading Flat File (date) into ODS

Hi.

I have to load flat file data into ods. Flat file has one <b>date</b> field. its format in file is <b>14/06/2006</b>. But system takes as <b>yyyymmdd</b>. so it is not being loaded.

In excel file also when i am trying to change 14/06/2006 to 20060614 format.It is not being changed.

Please help in this matter.

Saurabh Tiwari

saurabh.tiwari11@gmail.com

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 08:19 AM

    Hi,

    set length of your date filed in transfer structure to 10 (for dd/mm/yyyy). Then change format in transfer rules to yyyymmdd, you can do either by routine or formula. Are you familiar in creating fomulas and / or routines?

    Best regards,

    Björn

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2006 at 08:21 AM

    Hi,

    Right click on Excel cells (select all date column cells)>format cells->'Number' tab--->select 'text'.Save the flat file..

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 08:23 AM

    Surabh

    In excel sheet where you are giving the value of date, change the format of cell to General/Text. (Right click on cell & enter format cell...here give format as General/Text). This will solve your problem

    Also can you explain what do you meanby "In excel file also when i am trying to change 14/06/2006 to 20060614 format.It is not being changed" ...what exactly happens when you try to do this.

    Regards

    Pradip

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.