10-31-2006 6:00 AM
Hi,
I am getting date format as DD.MM.YYYY
is it possible to change format ?
10-31-2006 6:02 AM
Hi,
If it is related to table entries in that format then
go to SU3 and change user setting ...
change date setting.
various options are there.
Please mark all helpful answers.
10-31-2006 6:01 AM
Hi,
chk this.
DATA: V_DATE_IN(10) TYPE C,
V_DATE_SAP TYPE SY-DATUM.
V_DATE_IN = '01.01.2005.'.
CONCATENATE V_DATE_IN+6(4) "<--for Year
V_DATE_IN+3(2) "<--for month
V_DATE_IN+0(2) "<--for Day
INTO V_DATE_SAP.
now V_DATE_SAP will have value like 20060101.
rgds
anver
if hlped pls mrk points
10-31-2006 6:02 AM
Hi,
If it is related to table entries in that format then
go to SU3 and change user setting ...
change date setting.
various options are there.
Please mark all helpful answers.
10-31-2006 6:02 AM
Hi janki,
1. The date format inside the field is always YYYYMMDD.
2. The default format (for display purpose)
is based upon user settings.
3. If we want in some other format,
then we need to write extra code for it
4. using OFFSET
5. eg. mm.dd.yyyy
CONCATENATE MYDATE4(2) '.' MYDATE6(2) '.' MYDATE(4)
INTO DTS.
regards,
amit m.
10-31-2006 6:03 AM
Hi Janki ,
yeah it is possible to change format.
so to which date format u want to change ?..
regards,
vijay.
10-31-2006 6:04 AM