topic Re: Convert float to date in Application Development and Automation Discussions

Convert float to date

david_fryda2 — Mon, 29 May 2006 12:38:24 GMT

Hello everyone,

I need to convert "2.006123100000000E+07" to a date format.

How can I do it ?

Thanks in advance.

Re: Convert float to date

rahulkavuri — Mon, 29 May 2006 12:42:20 GMT

JUST EDITED THIS ONE, NOW U GET THE VALUE INTO THE STRING>>>


REPORT GEN.
DATA : float TYPE f.

DATA : string(15) TYPE c.

float = '21.12345'.

CALL FUNCTION 'FLTP_CHAR_CONVERSION'
EXPORTING
DECIM = 0
* EXPON = 0
input = float
* IVALU = ' '
* MASKN = ' '
IMPORTING
flstr = string
.

WRITE :/ float.
WRITE :/ string.

Re: Convert float to date

Former Member — Mon, 29 May 2006 12:47:36 GMT

Hello David,

You could it like this:

DATA:

zlv_float TYPE f VALUE '2.006123100000000E+07',

zlv_integer TYPE i,

zlv_date TYPE d.

zlv_integer = zlv_float.

write zlv_integer to zlv_date.

Regards,

John.

Re: Convert float to date

david_fryda2 — Mon, 29 May 2006 12:48:02 GMT

Hi Rahul,

If I put the following float "2.006123100000000E+07" instead "41.356661234", it gives me a dump.

Thanks.

Re: Convert float to date

Former Member — Mon, 29 May 2006 12:48:40 GMT

hi ,

use convert key word.

that is

syntax

CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t.

Example

CONVERT TIME STAMP lv_timestamp TIME ZONE SY-ZONLO INTO DATE d TIME t.

lv_timestamp type should be TIMESTAMP or TIMESTAMPL,

Mark Helpfull answers

Reagrds

Mark Helfull answers.

Re: Convert float to date

suresh_datti — Mon, 29 May 2006 12:49:40 GMT

Hi david,

try CTCV_CONVERT_FLOAT_TO_DATE.

regards,

Suresh Datti

Re: Convert float to date

david_fryda2 — Mon, 29 May 2006 12:51:08 GMT

Thanks John,

It works.

Here are the rewards....

Enjoy

Re: Convert float to date

Former Member — Mon, 29 May 2006 13:48:14 GMT

Hi John,

Looks good logic but when i give the f value '2.006123200000000E+07' it is printing the date as

32122006. This date is not valid

Hope we need to validate the date while conversion.

DATA:

zlv_float TYPE f VALUE '2.006123200000000E+07',

zlv_integer TYPE i,

zlv_date TYPE d.

zlv_integer = zlv_float.

write zlv_integer to zlv_date.

write zlv_date.

Re: Convert float to date

rahulkavuri — Mon, 29 May 2006 13:50:22 GMT

HI PLEASE TRY OUT WITH THE CODE I HAVE GIVEN, IT WORKS PERFECTLY ACCORDING TO THE REQUIREMENT

BY THE WAY THIS IS JUST THE WAY TO GET FLOAT INTO ANOTHER VARIABLE... IF U WANT THAT TO BE VERIFIED THEN U NEED TO DO THAT MANUALLY USING SOME CODE

Re: Convert float to date

Former Member — Mon, 29 May 2006 14:29:20 GMT

Hi Aluru,

Just add 'DD/MM/YYYY' and you will get a perfect date:

write zlv_date dd/mm/yyyy.

John.

Re: Convert float to date

Former Member — Mon, 29 May 2006 14:40:39 GMT

REPORT  ychatest                                .

DATA : p_float TYPE f,
       p_date LIKE cawn-atwrt,
       p_flt LIKE cawn-atflv,
       p_dt LIKE sy-datum.
.

p_float = '2.006123100000000E+07'.
p_flt = p_float.

CALL FUNCTION 'CTCV_CONVERT_FLOAT_TO_DATE'
  EXPORTING
    float = p_flt
  IMPORTING
    date  = p_date.

WRITE : p_date TO p_dt DD/MM/YYYY.

WRITE : p_dt.

Re: Convert float to date

erovneiko — Thu, 16 Nov 2023 11:01:06 GMT

date = CONV char8( CONV i( float ) ).