Qdabra qRules

Re: How to use Qrules DateDiff to calculate time difference

Hilary Stoupa — Fri, 23 May 2014 16:19:45 GMT

Okay - want to attach your form under the Options tab and I'll give you hand?

Re: How to use Qrules DateDiff to calculate time difference

d24n4e — Fri, 23 May 2014 10:11:16 GMT

I actually realised I needed to use totalminutes not minutes for my component and this appears to now work! Thank you

Re: How to use Qrules DateDiff to calculate time difference

Hilary Stoupa — Wed, 07 May 2014 14:39:18 GMT

I think you need to calculate the minutes then divide the result by 60.

How to use Qrules DateDiff to calculate time difference

d24n4e — Wed, 07 May 2014 13:54:38 GMT

Does anyone have a walkthrough for using DateDiff to calculated total hours time difference please?

For some reason I cannot get time difference to calculate correctly. I used Qdrules Lab 5 to help me and have changed the component to hours, but if I put Start Time 12/05/14 18:30 and End Time 12/05/14 20:00 the Hours field shows 1.00 and not 1.5

Date 1 is set as Date Time

Date 2 is set as Date Time

Difference is set as decimal double (with translate(., "-", "") in the value field to prevent displaying a minus sign in front of the hours calculation)

Many thanks