Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

getting month

Hi,

How do I get Month from creation date.

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

Thanks

Veni.

Tags:
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question