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

date format

output of report is showing correct format i.e

14.08.2008

but when downloaded to excel format it has changed to

08/14/2008

i want the above format in excel how to get that?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 06:04 AM

    U ca change the date format in excel by...

    1. Go to control panel->Regional and Language Options.

    2. Press Customize

    3. Press Tab 'Date'

    4. Change the short date format.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 06:03 AM

    Hi

    Use FM

    CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

    regards

    BS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 06:05 AM

    Hi asks,

    Make use of this write statement.

    I hope default application server date is triggering for over coming from that try this.

    write: sy-datum USING EDIT MASK '__.__.____'.

    Cheers!!

    Balu

    Edited by: Balu CH on Oct 21, 2008 11:41 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2008 at 06:08 AM

    Hi ,

    if u want the same date format ..before writing to file

    SET COUNTRY 'US'.

    after completion that use the

    SET COUNTRY SPACE.

    diff format is becase that u r doing in diff location and server time differ format.. so like that u r coming ..

    Regards,

    Bharani

    Edited by: SeethaRamaiah Bharani on Oct 21, 2008 8:08 AM

    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.