Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Function module for date format

Former Member
0 Kudos
516

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.

5 REPLIES 5

Former Member
0 Kudos
201

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
0 Kudos
201

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
0 Kudos
201

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
0 Kudos
201

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
0 Kudos
201

try this

REPORT ZTEST.

DATA: V_DATE(10).

V_DATE = '28-02-2007'.

TRANSLATE V_DATE USING '-.'.

WRITE : V_DATE.