topic Re: hidden field: Date in ArcGIS Survey123 Questions

hidden field: Date

RhondaThynne — Fri, 20 May 2016 17:34:25 GMT

For each of my related tables I have 2 hidden fields; one for site code and the other for date.

The site code is populated correctly, but the date is populated with a number that looks nothing like a date!

I have included a screen shot of the survey form as well as the related table with the date circled in red.

Any help is appreciated!

Rhonda

Re: hidden field: Date

GaryBowles1 — Fri, 20 May 2016 18:21:18 GMT

Rhonda,

The date is in EPOCH time. See Dates and Time in Survey123 for ArcGIS Ismael's blog post and hopefully it will explain all you need for this.

--gary

Re: hidden field: Date

IsmaelChivite — Sat, 21 May 2016 00:04:27 GMT

HI Rhonda, I am guessing that if you try using the bind::esri:fieldType column in your survey worksheet and set the value to esriFieldTypeDate for your hidden date question, your date will be stored as you wish. I have not tried myself, but I think it may work. Some more info about the esri:fieldType column can be found here: Mapping XLSForm questions into ArcGIS Feature Service fields

Re: hidden field: Date

RhondaThynne — Wed, 01 Jun 2016 18:44:22 GMT

Hi Ismael,

I do have the bind::esri:fieldType column in my survey worksheet and the value is set to esriFieldTypeDate.

I did some testing and it turns out the hidden date that is within a repeat will display the date as EPOCH time (I'm assuming), but when the hidden field is NOT within a repeat the date is in a common format (June 1, 2016).

Is this a bug that I was not aware of? If it is not a known bug, should I log it under ESRI/Survey123Community Issues?

Thanks for your feedback!

Rhonda

Re: hidden field: Date

RhondaThynne — Wed, 01 Jun 2016 18:45:45 GMT

Thank you, Gary. I replied to Ismael's comment below, it appears to only display EPOCH time within a repeat.

Thanks for the link on Dates/Time in Survey123!

Re: hidden field: Date

IsmaelChivite — Wed, 01 Jun 2016 18:57:22 GMT

Hmmm, this looks at first sight as a software defect. Let us research a bit more. Marika Vertzonis

Re: hidden field: Date

RhondaThynne — Wed, 01 Jun 2016 19:25:40 GMT

Thank you. Please let me know if you need any other details from me

Re: hidden field: Date

IsmaelChivite — Sat, 04 Jun 2016 00:33:56 GMT

We were able to reproduce this behavior. We will add to the backlog for resolution. If this is absolutely critical for your workflow, please open a formal Esri Technical Support incident to be prioritized. Thanks a lot.

Re: hidden field: Date

RhondaThynne — Sun, 12 Jun 2016 01:33:55 GMT

Thank you for looking into this!