Re: Calculating Total Number of Days Based Off 4 Different Date Picker Fields

Hilary Stoupa — Wed, 13 Feb 2013 15:50:32 GMT

InfoPath has a function to add days to a date, but nothing built in for calculating the differences between them. qRules can do this for you (and much more) if a third party tool is allowable in your environment. Otherwise, I have seen some rule-based date calculations - here's a sample form that someone posted the other day while we were trying to work out why a time calculation wasn't working any longer when he upgraded to IP 2010.

Calculating Total Number of Days Based Off 4 Different Date Picker Fields

r.iqbal87 — Tue, 12 Feb 2013 21:01:06 GMT

Hello all,

I apologize in advance if this topic has been posted in the past. I have searched through the forum and attempted numerous techniques posted but have been unable to get this to work. I figure my situation is quite unique, therefore the threads found here may not apply to my situation so I decided to inquire about my issue in its own thread.

Anyways, here's the situation:

I am attempting configure a field within my InfoPath form, that calculates total number of days a patient has spent within the ICU. The total number of days is to be calculated based off of 4 different fields, which are all bound to Date Picker controls. I am using InfoPath 2013, and the form is in compatibility mode since it is a browser enabled form, hosted on a server running SharePoint 2007.

Essentially, this is what I am trying to do:

Names of the 4 different fields involved in the calculation:

Admission_Data_icu_admit_date

(Data type: Date (date))

Admission_Data_transfer_date

(Data type: Date (date))

Admission_Data_icu_readmission_date

(Data type: Date (date))

Admission_Data_second_transfer_death_date

(Data type: Date (date))

Name of field the calculated value will appear in:
Admission_Data_total_icu_days
(Data type: Text (string))

( (Admission_Data_second_transfer_death_date) - (Admission_Data_icu_readmission_date) ) + ( (Admission_Data_transfer_date) - (Admission_Data_icu_admit_date) ) = Admission_Data_total_icu_days

I have attempted multiple approaches using rules, but to no avail.

If anyone can provide me some insight, or point me in the right direction, I would sincerely appreciate it.

Newbie Questions

Re: Calculating Total Number of Days Based Off 4 Different Date Picker Fields

Calculating Total Number of Days Based Off 4 Different Date Picker Fields