Re: Total Minutes between Date & Time Picker

Bre Huston — Thu, 12 Feb 2015 23:07:21 GMT

Hello Pinnacle7,

Date/Time calculations can get a bit tricky. the dateAdd function only does so much out of the box (OOB). I would recommend using qRules Date Diff command. This command will allow you to get the difference between two dates in whichever format you choose.

The syntax you would want in this instance would be: concat(" DateDiff /date1=", fieldwithStartDate, " /date2=", FieldWithResolvedDate, " /component=totalminutes")

Here's a link to qRules for some more info: http://www.qdabra.com/en/products/qRules_new.aspx

After that it would just be some testing and logic to break up your total minutes into days, hours and minutes.

Hope that helps!
Bre

Bre Huston | Project Manager
Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Total Minutes between Date & Time Picker

Pinnacle7 — Wed, 11 Feb 2015 16:07:22 GMT

Hi, I have a Change Request Form I need some help with. I have 2 dates - "Start Date" & "Resolved Date", both are Date & Time Picker Fields. I am looking for a solution that provides me with 2 answers: - The 1st is the Total number of minutes between Resolved and Start - The Second is displaying that Total number of minutes as Text in this format "0 days, 00hrs, 00mins" so for Example: Start Date = 11th Feb 09:00am Resolved Date = 12th Feb 10:10am I would like to see: Total Minutes = 1510 Total Total (display) = 1 days, 01hrs, 10mins

General

Re: Total Minutes between Date & Time Picker

Total Minutes between Date & Time Picker