topic Re: Arcade Date expressions in ArcGIS Field Maps Questions

Arcade Date expressions

LouiseHarris1 — Wed, 25 Oct 2023 10:08:54 GMT

I am configuring a form in Field Maps and want to auto calculate the date so have chosen to use Now(), however this also adds a time. What do I need to add to this function so it only auto fills with a date not a time too?

Re: Arcade Date expressions

DanPatterson — Wed, 25 Oct 2023 10:28:02 GMT

DateOnly looks promising

Date functions | ArcGIS Arcade | ArcGIS Developers

Re: Arcade Date expressions

LouiseHarris1 — Wed, 25 Oct 2023 11:06:52 GMT

Yeah I tried that - DateOnly() but it doesn't work. I get the following message:

Test execution error: Compilation error - Line : 1, 0: Function not found. Verify test data

Re: Arcade Date expressions

KenBuja — Wed, 25 Oct 2023 13:49:30 GMT

Are you using Enterprise? This new capability was just released in v1.24 and is only available in ArcGIS Pro 3.2, ArcGIS Online, and ArcGIS Maps SDK for Javascript 4.28. If you're on AGOL, this should be available after tonight's upgrade.

Re: Arcade Date expressions

DougBrowning — Wed, 25 Oct 2023 14:05:59 GMT

All dates must have a time in Esri databases. New fields for date only are coming very soon (maybe last night?).

If you want to just not show the time you can try setting the popup in the map and it may use that in the form. It will still store a time. 123 does noon not sure on Field Maps. It often uses midnight which causes issues later with time zone conversions. So I just leave the time now.

Re: Arcade Date expressions

JustinReynolds — Wed, 25 Oct 2023 15:00:21 GMT

While you wait for the DateOnly() function with to become available you can use the following:

Set the field's input type to "date" rather than the default "date and time". The user will then only see the date.

You can also use Today() instead of Now(). Today returns the current date at midnight, which is what will be stored in the database, but since you set the input type "Date" the user will of course only see the date.

Re: Arcade Date expressions

DougBrowning — Thu, 26 Oct 2023 14:10:02 GMT

I think this may default the time to midnight though. Then it may show the day before when using the value in a web map that is in a different timezone. Happens to me, esp with Alaska, and our users call about it.