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

[vocono1953]

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

[ZacharySutherby]

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. 

[vocono1953]

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.

[IsmaelChivite]

today() should all be lowercase.

[vocono1953]

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

Thanks anyway.

[JenniferAcunto]

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. 

[vocono1953]

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

Thanks for the help.

[JenniferAcunto · Accepted solution]

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

[vocono1953]

Very nice! That fixed it.

Thank you.