topic Re: date format in Application Development and Automation Discussions

date format

Former Member — Tue, 10 Apr 2007 06:47:42 GMT

i need to change the date format rom ddmmyyyy to yyyymmdd. i know this can be done using edit mask. but i don't know the syntax for this , could any one plz.

Re: date format

Former Member — Tue, 10 Apr 2007 06:50:03 GMT

hi sunil,

1. we can take another variable and using offset concept we can do that.

2. concatenate mydate4(4) mydate2(2) mydate(2)

into newdate.

Re: date format

Former Member — Tue, 10 Apr 2007 06:51:54 GMT

How we can write using edit mask

Re: date format

Former Member — Tue, 10 Apr 2007 06:52:10 GMT

Hi,

In SAP all the dates are stored in the format YYYYMMDD only.

if you are getting that field from somewhere just keep as it is:

if you wants from ddmmyyyy to yyyymmdd:

data: date(8), date1(8), mon(2),day(2),year(4).

date = ddmmyyyy

year = date+4(4).

mon = date+2(2)

day = date+0(2).

concatenate year mon day into date1.

reward if useful

regards,

ANJI

Re: date format

Former Member — Tue, 10 Apr 2007 06:52:43 GMT

Hi Sunil,

Hope this code helps you.

data mydate like sy-datum.

data: year(4) type c,

month(2) type c,

date(2) type c.

year = mydate(4).

month = mydate+4(2).

date = mydate+6(2).

write: / year no-gap, month no-gap, date.

reward if helpful.

Regards,

Thasneem

Re: date format

Former Member — Tue, 10 Apr 2007 06:53:00 GMT

Hi,

You can use the below syntax for this one

concatenate mydate4(4) mydate2(2) mydate(2)

Even you can use the Function module CONVERT_DATE_TO_INTERNAL to convert the internal format.

Regards

Sudheer

Re: date format

Former Member — Tue, 10 Apr 2007 06:54:02 GMT

fromdate4(4) = sy-datum0(4).

fromdate+2(2) = write month.

fromdate+0(2) = write days

Re: date format

Former Member — Tue, 10 Apr 2007 06:54:26 GMT

sunil,

Here s_date is your date input field.

concatenate s_date4(4) s_date2(2) s_date+0(2) into s_date.

Don't forget to reward if useful...

Re: date format

Former Member — Tue, 10 Apr 2007 06:55:15 GMT

WRITE /(30) sy-datum USING EDIT MASK

'RRThe duration is ____/__/__'.

Here are some of available options..

... DD/MM/YY | MM/DD/YY

| DD/MM/YYYY | MM/DD/YYYY

| DDMMYY | MMDDYY | YYMMDD

Reward if helpful...

Re: date format

Former Member — Tue, 10 Apr 2007 06:56:01 GMT

Hi Sunil,

Check with this please...

data : m like sy-datum..

write sy-datum to m using edit mask '__ __ __'.

write m.

Hope this helps you, reply for queries, Shall post you the updates.

Regards.

Kumar

Re: date format

anversha_s — Tue, 10 Apr 2007 07:00:06 GMT

hi,

chk this.

data : v_date1(10) value '23/02/2007',
         v_date(8).
 
concatenate  v_date1+6(4) v_date1+3(2) v_date1+0(2) into v_date.


OR 


data : v_date1 TYPE KCDE_INTERN_VALUE,
v_date2 TYPE KCDE_INTERN_VALUE.

CALL FUNCTION 'KCD_EXCEL_DATE_CONVERT'
EXPORTING
EXCEL_DATE = v_date1
DATE_FORMAT = 'TMJ'
IMPORTING
SAP_DATE = v_date2
EXCEPTIONS
OTHERS = 0.

Regds

Anversha

Re: date format

former_member673464 — Tue, 10 Apr 2007 07:02:38 GMT

hi,

Dont have any edit mask to write in format yyyymmdd.But we have format yymmdd Here is syntax for that edit mask.

WRITE: sy-datum, / sy-datum yymmdd.

regards,

veeresh

Re: date format

Former Member — Tue, 10 Apr 2007 07:05:31 GMT

But the complete year is not coming, as its coming 07 but i need 2007

Re: date format

Former Member — Tue, 10 Apr 2007 07:08:42 GMT

Hi..,

u can write it as ..

sorry..

try this.. its working..

WRITE: sy-datum, / sy-datum using edit mask '____.__.__'.

or use this .. to eliminate the separators also..

WRITE: sy-datum, / sy-datum using edit mask '________'.

reward all helpful answers ..

sai ramesh

Re: date format

Former Member — Tue, 10 Apr 2007 07:14:12 GMT

Hi Sunil,

Check this info.

Use function module CONVERT_DATE_TO_EXTERNAL. This will convert the date to the user specific format. So if your user specific format is mm/dd/yyyy, then this is all you need.

Hope this resolves your query.

Reward all the helpful answers.

Regards