topic Re: Regarding the date format in Application Development and Automation Discussions

Regarding the date format

Former Member — Tue, 02 Dec 2008 12:03:56 GMT

Hi,

My requirement is:

We have to generate a batch number in such a way that

the first character should be the last digit of the current date

the second character should be the month identifier(1-9 from Jan to sept and for the rest Oct-A Nov-B and Dec-C)

the third character should be the day identifier(for dates 1-9,its 1,2..9 and for the rest consecutive dates starting frm a,b,...v)

Please help me how to achive this.

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:13:19 GMT

You can use SPLIT or OFFSET key words to get what you want

for further info go through the KEY word documentaion where examples are provided

Regards

Ramchander Rao.k

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:16:27 GMT

Hi,

Just declare a string variable which stores the batch number. Declare 3 more variable to store all other information. And then concatenate all variables to get a unique batch number.

Implement this logic. Hope this will be helpful for you.

Thanks

Nitesh

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:18:22 GMT

U can do this by using Character String Operations on DATE and based on value use IFELSE control statement.

like ur DATE is 20081202 then

if date+6(2) = 01.

c3 = 1.

elseif date+6(2) = 02.

endif.

but this is simple way , u can find some more optamize way.

Regards

Sachin

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:19:12 GMT

That is okay...but i want to know the logic how to increment the numbers and continue with the alphabets progressing...Since for the days, we need to go on from A to V, how to implement that?

Edited by: Aish S on Dec 2, 2008 1:21 PM

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:25:06 GMT

Hi,

Just use case statement for that.

Thanks

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:45:48 GMT

If we use the case statement, for the dates from 10 to 31st, case statemnt would be very lengthy.Is there any other possible way for this?

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:59:03 GMT

Hello


pointer type i.
if day LE 9.
  third_character = day.
else.
  pointer = day - 10.
  third_character = SY-ABCDE+pointer(1).
endif.

Re: Regarding the date format

Former Member — Tue, 02 Dec 2008 12:59:14 GMT

Hi,

I think you will have to go for case only. No other go.

Thanks

Nitesh

Re: Regarding the date format

Former Member — Wed, 03 Dec 2008 04:39:20 GMT

Thanks a lot Maroz....it has worked perfectly....