Function module for date format

[Former Member]

Hi,

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

Thanx.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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 .

<b>Elaborate teh query with an example .</b>

check this

regards,

vijay.

[Former Member]

try this

REPORT ZTEST.

DATA: V_DATE(10).

V_DATE = '28-02-2007'.

TRANSLATE V_DATE USING '-.'.

WRITE : V_DATE.