Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

date format

Former Member
0 Kudos

Hi,

I am getting date format as DD.MM.YYYY

is it possible to change format ?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

5 REPLIES 5

anversha_s
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Janki ,

yeah it is possible to change format.

so to which date format u want to change ?..

regards,

vijay.

Former Member
0 Kudos

Thanks all for quick help.

Problem solved.