topic Re: hOW TO in Application Development and Automation Discussions

hOW TO

Former Member — Wed, 08 Aug 2007 19:54:31 GMT

Hello

I need too know how to convert from

2.0060315000000000E+07 to 2006.03.15

I have the code something like:

data: a type ATFLV, b type DATUM.

a = 2.0060315000000000E+07.

How to convert to

b = 2006.03.15 ??

Thanks!!

Gabriel

Message was edited by:

Gabriel Fernando Pulido V.

Re: hOW TO

Former Member — Wed, 08 Aug 2007 20:00:59 GMT

Hi Gabriel,

Check this function module <b>CTCV_CONVERT_FLOAT_TO_DATE</b>.

Thanks,

Vinay

Re: hOW TO

RichHeilman — Wed, 08 Aug 2007 20:01:06 GMT

If your user specifc settings for the date format are YYYY.MM.DD, then this coding will work.




data: a type f,
      n(8) type n,
      b type DATUM,
      c(10) type c.

a = '2.0060315000000000E+07'.
n = a.
b = n.
write b to c.

write:/ c.

Regards,

RIch Heilman

Message was edited by:

Rich Heilman

Re: hOW TO

Former Member — Wed, 08 Aug 2007 20:01:54 GMT

Hi,

Please try FM CTCV_CONVERT_FLOAT_TO_DATE.

Regards,

Ferry Lianto

Re: hOW TO

RichHeilman — Wed, 08 Aug 2007 20:04:02 GMT

Or if your user specific format is not like that and you need to force that formatting, you can do this.



data: a type f,
      n(8) type n,
      b type DATUM,
      c(10) type c.

a = '2.0060315000000000E+07'.
n = a.
b = n.

concatenate b(4) '.' b+4(2) '.' b+6(2) into c.

write:/ c.

Regards,

RIch Heilman