AnsweredAssumed Answered

Age Calculation Error "xpath type mismatch exception invalid"

Question asked by ABasinAdmin on Aug 2, 2020
Latest reply on Aug 5, 2020 by ABasinAdmin

I have a text field to collect a date of birth in mm-dd-yyyy. I then have a series of calculations to convert it to yyyy-mm-dd and turn it into a date field whereby I can then calculate a persons age. The age makes subsequent questions relevant or not (ie. is the person a minor or not). This works in my original form.

 

I created a new form and copy and pasted that section into the new form for the same purpose. The new form now gives me an error message:

 

 

Below is the sample of the xls form with the dob/age calculations:

 

 

 

 

I initially did the 'paste only values' and I've tried deleting the cells and then rewriting from scratch, but both had no effect. I've checked the sheet for any connections and there are none. In the original form, the dob/age calculations are within a repeat and are not in the new form, but I don't see how that would affect this.

 

Help!

 

RyanE

Outcomes