date format

[Former Member]

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?

[Former Member]

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?

[Former Member]

Hi

Use FM

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

regards

BS

[Former Member]

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.

[Former Member]

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

[BH2408]

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