topic Re: Date conversion functon module in Application Development and Automation Discussions

Date conversion functon module

Former Member — Mon, 24 Mar 2008 08:51:24 GMT

Hi All,

Coud you please some body let me know what is the function module that I can use to convert date format to user specific date format.Using the function module SLS_MISC_GET_USER_DATE_FORMAT I am getting the date format settings of that particular user after that how to convert my dateformat(MM.DD.YYYY always) to the userspecific format.

Regards

Mahesh

Re: Date conversion functon module

former_member210123 — Mon, 24 Mar 2008 08:54:13 GMT

this command is more than useful i suppose.

WRITE sy-datum TO:

date_mask DD/MM/YYYY.

Re: Date conversion functon module

former_member210123 — Mon, 24 Mar 2008 08:56:24 GMT

This function module is usally used for this purpose.It also checks the whether the entred date is correct.DATE_CONV_EXT_TO_INT

Re: Date conversion functon module

Former Member — Mon, 24 Mar 2008 09:02:13 GMT

Hi,

Use DATE_CONV_EXT_TO_INT.

Reward points if this helps,

Kiran

Re: Date conversion functon module

Former Member — Mon, 24 Mar 2008 09:08:30 GMT

Hi ,

Make use of FM.

FORMAT_DATE_4_OUTPUT

example.

Import parameters Value

DATIN 01.02.2007

FORMAT MM.DD.YYYY

Export parameters Value

DATEX 02.01.2007

Regards,

Balakumar.G.

Reward Points if helpful.

Re: Date conversion functon module

Former Member — Mon, 24 Mar 2008 09:23:36 GMT

hi,

the function module is DATE_CONV_EXT_TO_INT

or you can change date format by

ate-date = sy-datum.

APPEND date.

DATA: dd TYPE string.

DATA: mm TYPE string.

DATA: yyyy TYPE string.

LOOP AT date.

dd = date-date+6(2).

mm = date-date+4(2).

yyyy = date-date+0(4).

yyyy = date-date+2(2).

CONCATENATE dd yyyy mm INTO date-date1.

WRITE sy-datum DDMMYY.

MODIFY date .

ENDLOOP.

if helpful give rewards points

regards,

pankaj vashista