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]

Hi,

As u mentioned i substituted the values for that fields in a text object ,got 1.94

1-1.1*(num('17:26:19')-num('120:00:00'))/num('120:00:00')

[#3]

you can considrate any time 4 example: 10:11:13

[its_anandrjs]

Then convert it into Hour, Minutes or seconds from your requirement in the formula

Regards

Anand

[Anonymous]

1-1.1*(subfield(date_debut,':',1)*3600+subfield(date_debut,':',2)*60+subfield(date_debut,':',3)-subfield(date_fin,':',1)*3600+subfield(date_fin,':',2)*60+subfield(date_fin,':',3))/(subfield(date_fin,':',1)*3600+subfield(date_fin,':',2)*60+subfield(date_fin,':',3)) as offf

[Anonymous]

@youssef assenane:

is the above expr still not working?

[MarcoWedel]

=1-1.1*('17:26:19'-'120:00:00')/'120:00:00'

[#8]

it's still not working

[#9]

how you get that

[#10]

but why when i do  =1-1.1*(DUREE_INCIDENT-duree_trajet)/duree_trajet in text objet i get -27,176