Date formatting issues

MatthewMorehead — Tue, 06 Jun 2023 18:55:10 GMT

I am trying to format the date in my survey into YYYYMMDD so that it shows up nicely in my instance_name setting field. I am currently trying to use the following formula to format the date in the calculation line of my date question :

format-date(${DATEOFSURVEY}, '%Y: %n: %e')

Connect keeps returning an error saying it is "invalid"

XLSForm is attached, any help is appreciated.

Re: Date formatting issues

ZacharySutherby — Tue, 06 Jun 2023 20:55:51 GMT

Hello @MatthewMorehead,

The issue is due to the calculation being in the same line as the date question. This causes a circular dependency loop as a question cannot be calculated with it's own value.

If you don't need the formatted date stored in a field in the feature service you can take the same calculation and place it in the concat() function within the instance_name column. If you do want the formatted string in a field in the feature service you can add a calculate question following the DATEOFSURVEY question and reference that calculate question in the instance_name.

topic Re: Date formatting issues in ArcGIS Survey123 Questions

Date formatting issues

Re: Date formatting issues