Difference between two dates

[zied_ahmed1]

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

omarbensalem‌

[pradosh_thakur]

interval(field1-field2,'mm')

use this in any condition like if (interval(field1-field2,'mm') >30 , eepression1, expression2)

[PrashantSangle]

To find difference between two timestamp use

interval()

try like

interval(dateField1-dateField2,'mm')

Regards,

Prashant Sangle

[zied_ahmed1]

Hello ,

The answer is :

interval(Filed 2 - Field 1,'mm:ss')

Thanks for all

[zied_ahmed1]

I use this for the condition but it doesn't work :

if (interval(field1-field2,'mm') >30 , eepression1, expression2)

[pradosh_thakur]

where exactly are you using this? and if you need only minutes why using mm:ss?

[zied_ahmed1]

yes yes I delete the ss and i tryed

if ( interval(field1-field2,'mm') >30 , eepression1, expression2)

it doesn't work

[PrashantSangle]

Hi,

use if(num(num#( interval(field1-field2,'mm') >30)),epression1, expression2)

interval() is formatting function it wont convert actual data.

Regards,

[zied_ahmed1]

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 '

[PrashantSangle · Accepted solution]

Hi,

try

if(num(num#(interval(Field2-Field1,'mm'),'###'))>30,'Hello', 'No')

Regards