topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 31 Oct 2006 06:00:08 GMT

Hi,

I am getting date format as DD.MM.YYYY

is it possible to change format ?

Re: date format

anversha_s — Tue, 31 Oct 2006 06:01:19 GMT

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

Re: date format

Former Member — Tue, 31 Oct 2006 06:02:34 GMT

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.

Re: date format

Former Member — Tue, 31 Oct 2006 06:02:41 GMT

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.

Re: date format

Former Member — Tue, 31 Oct 2006 06:03:07 GMT

Hi Janki ,

yeah it is possible to change format.

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

regards,

vijay.

Re: date format

Former Member — Tue, 31 Oct 2006 06:04:28 GMT

Thanks all for quick help.

Problem solved.