numc value

[Former Member]

hi

I have a date field (8)and Line item field (len 6) ,

I have a field called Tripno(10)(Target Field )

So I want to convert the date field to NUMC( len 5) and Line item (5) and concatenate to Tripno which is length 10 , because iam sending the data of both fileds to Trip No. So please tell me the code to convert date Filed to Numc type of Len 5 .

Is there any convertion routines required for this ?

Thanks in advance

Edited by: ramesh222 on Sep 3, 2010 1:51 PM

[ThomasZloch]

So you want to store dates in length 5, did you already design a new calendar logic to accomplish this?

Thomas

[Former Member]

No i didnt designed , but in ecel when we take the date in number format we it shows 5 digit number right , like that is there function to convert the date to Numc

[Former Member]

Aaahh... XLS...

as far as i know there is no such function in SAP so you'll haev to write something yourself (which should not be hard).

Just keep in mind: 01-01-1900 equals value 1.

[Former Member]

so there is no way to convert to the date field to NUMC ? please any one tel me the code for that

Edited by: ramesh222 on Sep 3, 2010 2:48 PM