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

Date format Change

Posted on Aug 04, 2006 at 12:26 AM 12 Views

Hai All,

probably a simple question. I am downloading data from an ODS. I have dates int he format 8/3/2006. I need to upload this data after modifications as a flat file. But the date format in flat file needs to be in 20060803 format.

I am saving this data to excel.

How can I convert this automatically?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 06:52 AM
    2

    Hi,

    Goto System->user Profile->own data.

    Change the setting here and then check in the preview of transfer structure and original records.

    You can make changes here don't hav to write any code.

    Please reward.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 03:44 AM
    0

    Hi Visu,

    You can keep the date format as DD/MM/YYYY in the flatfile. Now in the transfer rules -> Datasource/Trans.Structure tab -> Goto the date field and if your scroll to the right you would find a column "Conversion" -> select "PDATE" as the conversion. You can then go ahead and load.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 03:46 AM
    0

    Hi Visu,

    The other option is to convert the date in the file itself. You would need to write a macro for that. The following post has the code for that:

    Bye

    Dinesh

    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.