topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 21 Oct 2008 06:00:42 GMT

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 — Tue, 21 Oct 2008 06:03:34 GMT

Use FM

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

regards

Former Member — Tue, 21 Oct 2008 06:04:48 GMT

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 — Tue, 21 Oct 2008 06:05:51 GMT

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 — Tue, 21 Oct 2008 06:08:33 GMT

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