10-21-2008 7:00 AM
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?
10-21-2008 7: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.
10-21-2008 7:03 AM
10-21-2008 7: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.
10-21-2008 7: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
10-21-2008 7: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