Application Development and Automation 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: 
Read only

date format

Former Member
0 Likes
581

Hi,

I am getting date format as DD.MM.YYYY

is it possible to change format ?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
557

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
Read only

anversha_s
Active Contributor
0 Likes
557

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

Read only

Former Member
0 Likes
558

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.

Read only

Former Member
0 Likes
557

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.

Read only

Former Member
0 Likes
557

Hi Janki ,

yeah it is possible to change format.

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

regards,

vijay.

Read only

Former Member
0 Likes
557

Thanks all for quick help.

Problem solved.