Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have two fields and i would like to have the difference between them :
The two fileds are timestamp
and I need to have condition the difference is > 30 minutes
Thanks
Hi,
try
if(num(num#(interval(Field2-Field1,'mm'),'###'))>30,'Hello', 'No')
Regards
interval(field1-field2,'mm')
use this in any condition like if (interval(field1-field2,'mm') >30 , eepression1, expression2)
To find difference between two timestamp use
interval()
try like
interval(dateField1-dateField2,'mm')
Regards,
Prashant Sangle
Hello ,
The answer is :
interval(Filed 2 - Field 1,'mm:ss')
Thanks for all
I use this for the condition but it doesn't work :
if (interval(field1-field2,'mm') >30 , eepression1, expression2)
where exactly are you using this? and if you need only minutes why using mm:ss?
yes yes I delete the ss and i tryed
if ( interval(field1-field2,'mm') >30 , eepression1, expression2)
it doesn't work
Hi,
use if(num(num#( interval(field1-field2,'mm') >30)),epression1, expression2)
interval() is formatting function it wont convert actual data.
Regards,
Hello Preshant,
I used this :
if(num(num#( interval(Field2-Field1,'mm') >30)),'Hello', 'No') and this is the result :
the value is 189 > 30 and it display 'No '
Hi,
try
if(num(num#(interval(Field2-Field1,'mm'),'###'))>30,'Hello', 'No')
Regards