Get date value from end field

Question

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!

ZenMasterZeke · Answer

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.

abureaux · Answer

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

ZenMasterZeke · Answer

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.