Question:
Hi,
I have a report .the same report is executed by two users
one user wants the date format column in O/P format as
dd.mm.yyyy and other user wants mm/dd/yyyy.
So to solve the above problem I have declared "date" data type as sy-datum .
AS per users request i go to su01 -->defaults ---> I enter date format then i execute the report and send them excel sheet .
My problem is
if the format is mm/dd/yyyy and if there is no value in date column it comes as "00/00/0000" . when i clear the field the o/p displays
" / / " . can anyone helpme to remove the slash.
if I change "date data type" as char then it wont change as per the system(su01)
Regard,
Abira
Answer:
If the Su01 record is set up correctly, the dates should be displayed in the users requested format anyway.
If not, then have a look at the SET COUNTRY Statement:
start-of-selection.
Write :/ sy-datum.
Set Country 'US'.
Write :/ sy-datum.
_________________
Regards
R
Abap KC
SFMDR
Answer:
Play with the MattG report: Manipulation of Date Format
_________________
MattG
Search SAPfans.
tWICE tULY iDIOT
Answer:
data p_date type dats .
data w_date(10) type c.
if not p_date is initial.
write p_date to w_date mm/dd/yyyy.
endif.
Will the above code solve your problem?
Thanks
Srini