topic Re: How to maintain date data in arcade expressions in ArcGIS Dashboards Questions

How to maintain date data in arcade expressions

Merlin — Tue, 14 Dec 2021 09:15:42 GMT

Hi,

allready some time ago I noticed that arcade wouldn't allow me to keep my exisiting date data after casting it into a dictionary. It was not possible to simply define the corresponding field in the dictionary as esriFieldTypeDate and then send my exisiting dates into that dictionary by using a for-loop.

As an example that didn't produce the desired results, but kept at least the existing date data:

Casting the date data into a string had the crucial disadvantage of not being able to filter that data in the dashboards anymore.

Unfortunatly the arcade documentation about dates didn't tell how to cast dates into UNIX epoch time, which is shown as one input for the date function, and seems to be the neccessary input for the esriFieldTypeDate in a dictionary.

Re: How to maintain date data in arcade expressions

Merlin — Tue, 14 Dec 2021 09:19:22 GMT

tl;dr: use the number() function in the for-loop to cast existing date data into UNIX epoch time, this can be read by the esriFieldTypeDate as correct date.

By trial and error I ended up trying the number() function on a date, which produces the UNIX epoch time, which is further down the line accepted by the esriFieldTypeDate in a dictionary.

I guess if there would have been an example showing this capabillity of the number() function in the documentation I would have found this solution way faster (google doesnt bring up anything useful either).
Maybe this could be inculded @DerekLaw ?

Well, here is an complete example of how to use the number() function in a way that keeps your exisiting date data alive:

Re: How to maintain date data in arcade expressions

SayedWali — Wed, 05 Jan 2022 07:18:02 GMT

Good tip! Exactly what I was after.

Re: How to maintain date data in arcade expressions

DavidNyenhuis1 — Thu, 15 Jun 2023 19:24:26 GMT

With this week's update to Arcade and ArcGIS Dashboards, date fields in feature set constructors now just work. You no longer have to wrap dates with Number() if you pass the dictionary into the FeatureSet() function (which as of this release accepts a dictionary as opposed to only text based JSON).

Instead of:

return FeatureSet(Text(dict))

Do this:

return FeatureSet(dict)

Learn more in this blog post.

NOTE: For Enterprise users, this update is targeted for 11.2

Re: How to maintain date data in arcade expressions

SayedWali — Mon, 19 Jun 2023 11:27:32 GMT

Yep, it worked, thank you!