Type mismatch converting text to date

Chris_976 — Thu, 02 Dec 2021 14:38:10 GMT

Hello there !

I'm coming accross some behaviour I can't explain no matter how many times I try to read and understand what @IsmaelChivite explains us in the post 'Dates and Time in Survey123' :

I have a form where I want my users to type a date of birth, and I find it easier for them to do that in a tex field formated as 'jj/mm/yyyy'.
Then I need to use this date to do the simple calculation of the age, so I calculate a text string to meet the ISO format

So from there I would expect the date(${ISOformatedDate}) function to give me the date in ESRI format and use it for calculation like "int((decimal-date-time(today()) - decimal-date-time(date(${ISOformatedDate})) div 365.25)". But the first step of using the date() function alone raises the error "Type mismatch converting text to date".

Moreover, when I try to calculate a date type field with the ISO formated string, it seems to work fine. But the same error is then raised when trying to use this field in another calculation...

So what's going on there and how can I do ?

Here is a sample of my sheet and, FYI, I'm using Survey123 Connect v.3.13

Cheers!

Re: Type mismatch converting text to date

js80540 — Mon, 25 Apr 2022 20:59:12 GMT

Did you ever find an answer?
I am having the same issue

Re: Type mismatch converting text to date

Chris_976 — Fri, 29 Apr 2022 05:31:29 GMT

Nope ! I put it aside for the moment as it's not a primary requirement in my survey... 😕
I'll try and look for a solution when I'll manage myself some time.

Re: Type mismatch converting text to date

RistoYlem — Mon, 04 Aug 2025 13:49:21 GMT

I have the same problem, does someone have a solution to this.

topic Re: Type mismatch converting text to date in ArcGIS Survey123 Questions

Type mismatch converting text to date

Re: Type mismatch converting text to date

Re: Type mismatch converting text to date

Re: Type mismatch converting text to date