convert date

[#1]

how can i calculate this instruction:

1-1.1*(date_debut-date_fin)/date_fin as offf

the problem is in the date i couldn't convert it into a number.

[Anonymous]

Try this:

1-1.1*(floor(num(date_debut))-floor(num(date_fin)))/floor(num(date_fin)) as offf

[Anonymous]

Use num function to covert it into a number

1-1.1*(num(date_debut)-num(date_fin))/num(date_fin) as offf

[#4]

no it doesn't work, for exampl if

date_debut:17:26:19

date_fin:120:00:00

i must have 1,94,but when tried the functions that you suggested i've got: 3,65

[MarcoWedel · Accepted solution]

The question is what you like to achive with this calculation, as it will deliver nearly 1 for all contemporary timestamps.

hope this helps

regards

Marco

[Anonymous]

I don't recognize that date format. What are the 3 (:) delimited parts?

[#7]

Have you checked that the dates are represented correctly before you convert them into numbers?

[#8]

it's time not date hh:MM:SS

[its_anandrjs]

Try this way also

Load

1 - 1.1 * ( Date( date_debut ) - Date( date_fin ) ) / Date( date_fin ) as offf

From Location;

Regards

Anand

[Jason_Michaelides]

What kind of timestamp is "date_fin:120:00:00"?