topic Re: Difference between two dates in Management & Governance

Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 10:36:56 GMT

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‌

Re: Difference between two dates

pradosh_thakur — Tue, 02 Jan 2018 10:41:29 GMT

interval(field1-field2,'mm')

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

Re: Difference between two dates

PrashantSangle — Tue, 02 Jan 2018 10:43:22 GMT

To find difference between two timestamp use

interval()

try like

interval(dateField1-dateField2,'mm')

Regards,

Prashant Sangle

Re: Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 11:07:43 GMT

Hello ,

The answer is :

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

Thanks for all

Re: Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 11:16:36 GMT

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

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

Re: Difference between two dates

pradosh_thakur — Tue, 02 Jan 2018 11:28:15 GMT

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

Re: Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 11:33:33 GMT

yes yes I delete the ss and i tryed

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

it doesn't work

Re: Difference between two dates

PrashantSangle — Tue, 02 Jan 2018 11:38:27 GMT

Hi,

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

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

Regards,

Re: Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 11:44:00 GMT

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 '

Re: Difference between two dates

PrashantSangle — Tue, 02 Jan 2018 11:53:59 GMT

Hi,

try

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

Regards

Re: Difference between two dates

zied_ahmed1 — Tue, 02 Jan 2018 12:32:09 GMT

Thank you it works

Re: Difference between two dates

pradosh_thakur — Tue, 02 Jan 2018 14:14:21 GMT

i think you just need num# here. num is not needed. Anyways if you are getting the answers it is well and good.