topic Re: Converting Date Formats in Application Development and Automation Discussions

Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 07:24:51 GMT

Hi all,

I know there are many such posts but i was unable to find an answer that suited my requirement.

I want to convert the internal date format into the format specified below. Is there any FM's for this or do i have to code it?

For Ex:

Internal Format : 20130218

Format Needed : 18th February 2013

I found the FM CONVERSION_EXIT_LDATE_OUTPUT but it does not add the th to the date.

Any Help will be greatly appreciated.

Thanks

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 07:33:21 GMT

Hello,

I have a suggestion for you, but is not actually such a good method.

You can try;

DATA: LV_DATUM(15).

CALL FUNCTION 'CONVERSION_EXIT_LDATE_OUTPUT'

EXPORTING

INPUT = P_DATUM

IMPORTING

OUTPUT = LV_DATUM.

REPLACE ALL OCCURRENCES OF '.' IN LV_DATUM WITH 'th'.

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 07:35:14 GMT

Hi,

I think for your requirement there is no function module available you have to write the code as below

please check the below link

http://scn.sap.com/thread/1112656

Definately it will help u.

Thanks

Mani

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 07:37:59 GMT

Thats what i thought i would have to do..

Thanks a lot..

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 07:38:54 GMT

Thank you Mani..

Re: Converting Date Formats

Bhushan_hs — Mon, 18 Feb 2013 07:44:10 GMT

Hi Kaeyur Rudra,

I don't think any function module would give you the desired result as expected by you.

But you can modify the function module based on your requirement.

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 08:39:45 GMT

Hi,

Write a simple select query on table T247.

Thanks,

Tooshar Bendale

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 08:43:06 GMT

Thanks Tooshar,

But doing that will give me the month in long form, not the whole date.

Thanks

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 08:43:26 GMT

Thanks Nagbhushan

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 08:53:27 GMT

Hi use the function module

HR_IN_GET_DATE_COMPONENTS

It will give the day, month and year.

Hope this helps.

Thanks,

Tooshar Bendale

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 09:03:36 GMT

The FM has a issue.

Month Day and Year are of type c( 1 char long). Hence when u pass sy-datum to it gives an exception since it cant take the whole of the month number..

Re: Converting Date Formats

vinoth_aruldass — Mon, 18 Feb 2013 09:05:58 GMT

hi,

with th will not come in any function module you have to write select query in t247 table and concatenate date 'th' month and year ..

hope it helps,

Vinoth

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 09:10:02 GMT

Hi,

You had entered a wrong date. Check the screen shot attached.

Thanks,

Tooshar Bendale

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 09:42:30 GMT

Thanks ,

It does work, but i have to add the th manually..

Thanks

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 09:43:05 GMT

Thanks everyone..

Guess i will have to add the th manually..

Re: Converting Date Formats

Former Member — Mon, 18 Feb 2013 10:33:35 GMT

hi , As suggested by Nagabhushan earlier, u can copy the FM and add the code after output statement.

data day1 type c.

day1 = output+1(1).

if day1 = 1.

replace all occurrences of '.' in output with 'st'.

elseif day1 = 2.

replace all occurrences of '.' in output with 'nd'.

elseif day1 = 3. replace all occurrences of '.' in output with 'rd'.

else. replace all occurrences of '.' in output with 'th'.

endif.

Thanks

Vijay

Re: Converting Date Formats

former_member225688 — Mon, 18 Feb 2013 10:42:14 GMT

Hi Rudra,

Its very simple. Just get the year date and month separated.

w_year = w_input+0(4) = 2013

w_date = w_input0+6(2) = 18

w_month = w_input0+4(2) = 02

Internal Format : 20130218

Assign the month name as per the month number we get in the w_month variable.

and the concatenate accordingly to get the final answer.

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 10:46:31 GMT

Thanks

Re: Converting Date Formats

former_member758034 — Mon, 18 Feb 2013 10:47:47 GMT

Thanks

Re: Converting Date Formats

gurunathkumar_dadamu — Mon, 18 Feb 2013 10:54:03 GMT

Hi Rudra,

yes,according to Dnyaneshwar follow the code and add this.

case w_month.

when '01'.

lv_name = 'January.

when '02'

lv_name = 'Febraury.

......

endcase.

concatenate w_date lv_name w_year into w_format.

Regards,

Gurunath Kumar D