topic Re: How is a Date Displayed as Read Only Text in Survey123 Connect? in ArcGIS Survey123 Questions

How is a Date Displayed as Read Only Text in Survey123 Connect?

vocono1953 — Tue, 15 Nov 2022 20:07:52 GMT

The function format-date was used to do this. Placing Today as an inline function call was rejected. Survey sees Today an element that does not exist in the app.

Also, I don't know what field format-date is placed.

Thank you for your help.

--Bob

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

ZacharySutherby — Tue, 15 Nov 2022 23:44:12 GMT

Hello @vocono1953,

Try placing format-date(today(), '%Y/%m/%d') in the calculate column of the XLSForm. Please see this documentation for more information on the format-date function.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

vocono1953 — Wed, 16 Nov 2022 15:46:37 GMT

Hi Zach,

Thank you for the advice. I paced it in the calculate column and the same error remains. It rejects the use of Date() as input. It may not be possible to do this. Any more thoughts?

Thanks again.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

IsmaelChivite — Wed, 16 Nov 2022 18:37:54 GMT

today() should all be lowercase.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

vocono1953 — Wed, 16 Nov 2022 19:54:46 GMT

Thank you for your input, Ismael. However, it resulted in the same error.

Thanks anyway.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

JenniferAcunto — Thu, 17 Nov 2022 13:52:09 GMT

The error shows ${Today()}. Did you put Today() as the question name? today() should be in the calculation column and your question name needs to be something like date_today and not a function.

It would be helpful at this point to include your survey XLS.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

vocono1953 — Thu, 17 Nov 2022 18:16:23 GMT

OK, Jennifer. Here is the XLS file. Please look at line 4.

Thanks for the help.

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

JenniferAcunto — Thu, 17 Nov 2022 18:49:46 GMT

format-date(today(), '%Y/%m/%d %H:%M')

Re: How is a Date Displayed as Read Only Text in Survey123 Connect?

vocono1953 — Thu, 17 Nov 2022 19:47:05 GMT

Very nice! That fixed it.

Thank you.