Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??????
Try: time_field2- interval('120:00:00','h:mm:ss') as toto
You can try
interval(time_field2-time_field1,'hh:mm:ss')
t:
load * inline [
time_field2, time_field1
07:21:54, 120:00:00
];
t2:
load
time_field2 - time_field1 as toto
Resident t;
It doesnt work guys i ve got. Anothervalue
please post sample app/data