topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Fri, 17 Aug 2007 07:15:33 GMT

hello all,

i want to convert date 2004/11/28 into 28-NOV-2004. can u pls help. it's urgent.

ritu

Former Member — Fri, 17 Aug 2007 07:17:50 GMT

Hi,

Check the fun modules

CONVERT_DATE_TO_INTERNAL and CONVERT_DATE_TO_EXTERNAL

or split the given date to YEAR,MONTH and DATE

and fetch the month description from the table T247

and concatenate the Date,month text and year into a string and use

Reward points for useful Answers

Regards

Nilesh

amit_khare — Fri, 17 Aug 2007 07:19:03 GMT

Welcome to SDN.

Refer the links with solutions for same issue -

Regards,

Amit

Reward all helpful replies.

varma_narayana — Fri, 17 Aug 2007 07:27:41 GMT

You have to Call the FM CONVERSION_EXIT_SDATE_OUTPUT.

Reward if Helpful

Former Member — Fri, 17 Aug 2007 07:36:20 GMT

Hi,

Try FM <b>CONVERSION_EXIT_SDATE_OUTPUT</b>

Input date should be 20071128 not 2004/11/28.

reward if useful.

Former Member — Fri, 17 Aug 2007 07:46:46 GMT

USE

CONVERT_DATE_TO_INTERNAL Function Module

reward points to all helpful answers

kiran.M

Former Member — Wed, 22 Aug 2007 10:58:29 GMT

thanx all of u.