topic Re: getting month in Application Development and Automation Discussions

getting month

Former Member — Wed, 10 May 2006 17:34:41 GMT

Hi,

How do I get Month from creation date.

If Creation date is 05/01/2004 then I want month as 05.

Thanks

Veni.

Re: getting month

RichHeilman — Wed, 10 May 2006 17:36:13 GMT

Here we are using substrings. The line of code below means that you what the value starting four characters to the left, and the following 2 characters.



data: month(2) type n.

month = creation_date+4(2).

Regards,

Rich Heilman

Re: getting month

Former Member — Wed, 10 May 2006 17:40:42 GMT

Veni,

VBAK-ERDAT+4(2) will give you the month.

I have given the sample code you were looking for in the other thread.

Regards,

Ravi

Note : Please mark the helpful answers

Re: getting month

Former Member — Wed, 10 May 2006 17:41:45 GMT

Hi Veni,

try this...

data: month(2) .

month = creation_date+0(2).

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Preety much..Thanks..All i considered was the above case..

Thanks..

Re: getting month

RichHeilman — Wed, 10 May 2006 17:48:35 GMT

Because all dates in R/3 are stored in the database and in memory as YYYYMMDD, not like the external format 05/01/2004. So at runtime, in order to access the month, you must move 4 places to the left and get the next two characters. Make sense?

Regards,

Rich Heilman

Re: getting month

Former Member — Wed, 10 May 2006 22:24:57 GMT

Hi Veni,

In SAP the date will be in the 20040501(YYYYMMDD) format.

For example if the creation date is 05/01/2004 it will be stored as 20060510 in SAP.To get the month use the substring.

data : Month(2).

Month = date+4(2)

This will give you the month 05.

Rgds,

Rama