topic Re: Get date value from end field in ArcGIS Survey123 Questions

Get date value from end field

ZenMasterZeke — Mon, 27 Nov 2023 16:24:47 GMT

Howdy!

I'm using Survey123 Connect v. 3.19, Enterprise 10.9. I'm trying to calculate just the date value, as a date type, from the 'end' question type (named end_date), but not having any luck.

I can get it as a string value using format-date(${end_date}, "%Y-%m-%d"), but I need a date value. Wrapping the format-date function in date() gives me a date, but with time as well. If I use just ${end_date} in the calculation, I get the epoch date format, ex. 1701102066.

Is there a way to do this, or am I stuck with the time value as well? Thanks!

Re: Get date value from end field

abureaux — Mon, 27 Nov 2023 20:24:13 GMT

Where are you using this date value? If it is inside of the Esri environment, I feel like the addition of time is something new. We have a date only field that time is being annoying injected into. But in our case, things worked fine in 10.9, but started acting up in 11.0.

If this is some other database, your format-date() should be enough. I regularly dump data like that into SharePoint without issue (A formatted date, not Esri's Epoch date. That requires converting in Power Automate first).

I assume you are using a date field?

Re: Get date value from end field

ZenMasterZeke — Tue, 28 Nov 2023 17:02:04 GMT

Thanks @abureaux . Currently trying a hidden field type, esriFieldTypeDate. Format-date gives me a text value in the correct format, but I want an actual plain date value data type. I can live without it, but would prefer it.

Re: Get date value from end field

abureaux — Tue, 28 Nov 2023 17:07:14 GMT

Have you tried type = date and appearance = hidden? The server may interpret that better.

Re: Get date value from end field

ZenMasterZeke — Tue, 28 Nov 2023 22:12:14 GMT

I'll give that a try. In general, don't like hidden appearance because it still takes up space on the form, but since it's at the end it may not matter.

Edit: still shows time. Not actual time, defaults to 12:00 pm. Oh well.