topic Re: Arcade date expression issue not working with QuickCapture in ArcGIS QuickCapture Questions

Arcade date expression issue not working with QuickCapture

ScumBagsSurfer — Thu, 11 Apr 2024 23:07:32 GMT

I have created a quick capture project and field map project using the same hosted feature layer. Within this layer, I have a date field which uses a calculated expression of:

Now()

which gets the current date and time of user input.

I then have a string field which formats this date to how I want.

An example of this would be

dd/mm/yyyy, hh:mm AM/PM

12/04/2024, 10:45 AM

This arcade expression is:

// Input Date

// AM or PM for minutes

var ampm = When(Hour(Now()) < 12, "AM", "PM");

// Getting current minutes/s

var minutes = Minute(Now());

// Adding 0 when the minute is a single digit

var paddedMinutes = When(minutes < 10, "0" + minutes, Text(minutes));

// Getting a current hour

var hours = Hour(Now());

// Adding 0 when the hour is a single digit

var paddedhours = when(hours<10,"0"+hours, Text(hours));

// Getting current day

var days = Day(Now());

// Adding 0 when the day is single digit

var paddeddays = when(days<10,"0"+days, Text(days));

// Adding 1 to adjust for zero-indexed months

var months = Month(Now()) + 1;

// Adding 0 when the month is single digit

var paddedmonths = when(months<10, "0"+months, Text(months));

// Final code

paddeddays +

"/" +

paddedmonths +

"/" +

ISOYear(Now()) +

", " +

paddedhours +

":" +

paddedMinutes +

" " +

ampm;

This is the result when I see the data in ArcGIS Online (see attached).

The dates where it is working are all points collected in field maps while the ones where it hasn't are all in QuickCapture.

Re: Arcade date expression issue not working with QuickCapture

KenBuja — Fri, 12 Apr 2024 14:25:54 GMT

This doesn't address the QuickCapture question, but you can get that formatting much easier using the Text function

Text(Now(), "DD/MM/YYYY, hh:mm A");

The only thing is doesn't address is the ISOYear, but I'm not clear on why you would want that. If you used your formula on a date like 31 December 2024, it would return "31/12/2025"

Re: Arcade date expression issue not working with QuickCapture

KenBuja — Fri, 12 Apr 2024 15:22:40 GMT

Which version of QuickCapture are you using? Arcade wasn't supported in versions before 1.18.

Re: Arcade date expression issue not working with QuickCapture

JohnathanHasthorpe — Mon, 18 Nov 2024 03:25:59 GMT

I have found that the original expression is failing in QuickCapture because of the comma followed by a space ", " . It looks like this is an ArcGIS Runtime bug. If you remove the comma the above will work.

But the following will work also: Text(Now(), "DD/MM/YYYY, hh:mm A");

Re: Arcade date expression issue not working with QuickCapture

ScumBagsSurfer — Sun, 14 Apr 2024 23:14:29 GMT

Thanks, I have tested this expression out and it seems to be working when I captured some test points.

Re: Arcade date expression issue not working with QuickCapture

kmsmikrud — Thu, 07 Nov 2024 17:57:28 GMT

Hi,

I'm experiencing similar values but I am trying to populate a text field with a text formatted date (MM/DD/YYYY).

I have similar arcade expressions in Field Maps, that work fine, but in QuickCapture arcade editor all looks well, but when I see the written values in ArcGIS Pro they are in epoch format. I'm using app version 1.20.22 and do not have spaces in the formatted expression.

The AGOL hosted feature layer is published with UTC time and then I have been adding new fields for Alaska CreationDate and AKDate (text format of date).

Thanks in advance, Kathy

Re: Arcade date expression issue not working with QuickCapture

JohnathanHasthorpe — Mon, 18 Nov 2024 04:06:50 GMT

We found a bug for this issue. It will be resolved in the December (1.21) release.

Re: Arcade date expression issue not working with QuickCapture

kmsmikrud — Mon, 18 Nov 2024 16:00:32 GMT

Great, thanks for looking into this and I look forward to the update in December. Thank-you!

Kathy

Re: Arcade date expression issue not working with QuickCapture

kmsmikrud — Tue, 17 Dec 2024 16:11:00 GMT

Update December 2024. The fix worked and text formatted date is now working :)!!