problem of time field

[#1]

hi guys,

i have two time fields  : time_field1=120:00:00 and the second one is time_field2= 07:21:54 .

when i create a text object and in the text field i put 07:21:54 -120:00:00 i got -4,69 and this is the right value.

but when i put it in the load by thier fields name,that's mean

load

time_field2-120:00:00 as toto

i've got another value.

any suggestions??????

[Gysbert_Wassenaar]

Try: time_field2- interval('120:00:00','h:mm:ss') as toto

[Anonymous]

You  can  try

interval(time_field2-time_field1,'hh:mm:ss')

[maxgro]

t:

load * inline [

time_field2, time_field1

07:21:54, 120:00:00

];

t2:

load

  time_field2 - time_field1 as toto

Resident t;

[#5]

It doesnt work guys i ve got. Anothervalue

[MarcoWedel]

please post sample app/data