topic Re: Function module for date format in Application Development and Automation Discussions

Function module for date format

Former Member — Wed, 28 Feb 2007 13:44:17 GMT

Hi,

what is the function module name to get the date format in (dd.mm.yyyy) from (dd-mon-yyyy)

Thanx.

Re: Function module for date format

Former Member — Wed, 28 Feb 2007 13:47:50 GMT

hi,

Look at the Function modules CONVERT_DATE_TO_INTERNAL or CONVERT_DATE_TO_EXTERNAL.

If the aboe are not useful, then you need to do it manually. just take date, Month and year in 3 fields and concatenate the same into another date field with the correct format.

Regards

Sudheer

Re: Function module for date format

Former Member — Wed, 28 Feb 2007 13:48:59 GMT

hi,

data: v_date(8) type c.

call function 'CONVERT_DATE_TO_INTERNAL'

exporting

date_external = '12.12.2006'

importing

date_internal = v_date.

write:/ v_date.

Regards,

Sruthi

Re: Function module for date format

Former Member — Wed, 28 Feb 2007 13:49:00 GMT

Hello,

Call this fuction module DATE_COMPUTE_DAY and then use this to convert to the day: DAY_NAMES_GET.

If I were you I'd store the day of week returned from DATE_COMPUTE_DAY in your cube in a new infoobject. Then bring in the text for the infoobject from table T246.

Vasanth

Re: Function module for date format

Former Member — Wed, 28 Feb 2007 13:53:34 GMT

try this Fm

CONVERSION_EXIT_SDATE_INPUT

input as dd-mon-yyyy

28FEB2007

im assuming mon in literal format.

output is 20070228

WRITE STATEMENT WILL DISPLAY THE DATA IN DEFALUT DATE FORMATS OF SU3 .

Elaborate teh query with an example .

check this

regards,

vijay.

Re: Function module for date format

Former Member — Wed, 28 Feb 2007 14:05:17 GMT

try this

REPORT ZTEST.

DATA: V_DATE(10).

V_DATE = '28-02-2007'.

TRANSLATE V_DATE USING '-.'.

WRITE : V_DATE.