topic Re: How to convert String date into date in Application Development and Automation Discussions

How to convert String date into date

Former Member — Thu, 08 Jan 2009 07:15:19 GMT

Hi,

I want to enter the month name into my input field i should convert into date.

Ex; if i enter my input fields JAN to APRIL.

these months should be convert into date format like 01 to 04.

Please help me.

nani

Re: How to convert String date into date

Former Member — Thu, 08 Jan 2009 07:18:05 GMT

Hi,

Check this table t247.

Re: How to convert String date into date

GauthamV — Thu, 08 Jan 2009 07:19:13 GMT

hi,

use this table and write logic accordingly.

T247

fields:

KTX - Month short text

LTX - Month long text

MNR - Month number.

Re: How to convert String date into date

Former Member — Thu, 08 Jan 2009 07:33:11 GMT

Hi,

Please refer this table T247 - Month name and short text

Use these fields MNR Month number

KTX Month short text

LTX Month long text

Regards,

Jyothi CH.

Re: How to convert String date into date

Former Member — Thu, 08 Jan 2009 07:33:41 GMT

Hi,

Check this FM

MONTH_NAMES_GET

Regards,

Omakram.

Re: How to convert String date into date

Former Member — Thu, 08 Jan 2009 08:01:10 GMT

Hi Nani,

Do it this way:

data:
  w_MNR type t247-MNR.

DATA:
  w_LTX type t247-LTX.

w_MNR = sy-datum+4(2).

select single LTX
  from T247
  into w_LTX
 where spras eq 'E'
   and MNR eq w_MNR.

write:
  w_LTX.

With luck,

Pritam.

Edited by: Pritam Ghosh on Jan 8, 2009 9:12 AM