nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade Calculation Expression - Local Date/Time Field - Offline - What to use?

kmsmikrud

Good Morning,

We publish our AGOL hosted feature layers with a UTC date/time knowing then the CreationDate and EditDates will be in UTC. In addition, we have been adding a local DateTime field that gets calculated based on the CreationDate field usually in a post-survey script process.

Now with arcade expressions, I wanted to use this functionality to auto-populate these fields, but I'm seeing discrepancies for what displays on the iPads then what writes to the AGOL feature layer tables. Also if the calculations recalculate when offline data is synced, then that is another consideration as posted here:

Below is one version I have started out with, which displays accurately in Field Maps in the layer form on the tablet, but when the data is synced from offline the date writes to the feature layer table in UTC.

//var dt_now_utc = Timestamp()
var akdt = Now()
//var akdt = ToLocal(dt_now_utc)
if (IsEmpty($feature.AKCreationDate)){
    return akdt;
}else{
    return akdt;
}

I have also tried to this which writes to the feature layer tables better (although if it recalculates when the offline edits sync, then this no longer works). This also isn't great because it displays in the tablet 8 hours behind the current time which doesn't look accurate even though it is writing to the tables accurately.

var dt_now_utc = Timestamp()
var akdt = DateAdd(dt_now_utc, -8, 'Hours')
if (IsEmpty($feature.AKCreationDate)){
    return akdt;
}else{
    return akdt;
}

What is the recommended arcade functions to get a local data time field to calculate using arcade expressions with offline data collection and for the data to be accurate when offline edits sync, do these values update then to the local time I think they do change.

Thanks in advance!,

Kathy

Vind meer berichten getagd met

Accepted answers

All comments

dougbrowning

Why did you comment out ToLocal? Have you tried

var akdt = ToLocal(Now())

kmsmikrud

Thanks for the reply.

I believe I commented it out, because I felt like 'ToLocal' wasn't working 'offline'. If Now provides the value in the local system of the client, why add the ToLocal(Now())? In reviewing the expressions, for one of the layers I have the following expression. Ideally all I want is the local time of the CreationDate that will work offline and not change when syncing offline edits.

The screenshot below shows the arcade expression and resulting datetime in Alaska or that was my goal. You can see the location Fix Time in UTC. The first few records in AKCreationDate look good, but we have a boat using Starlink so they are basically connected. Then the other records match the fix time and those were collected offline and those values were not converted to local datetime which leads me to believe ToLocal does not work offline.

var dt_now_utc = Timestamp()
var akdt = ToLocal(dt_now_utc)
if (IsEmpty($feature.AKCreationDate)){
    return akdt;
}else{
    return akdt;
}

dougbrowning

I have used it offline I think. Am testing that now. Now may show the current time for display but when it uploads to AGOL all times are converted to UTC for storage. So it makes sense to see that in the table. You cannot store in a time zone really its all UTC. At Dev Summit they did say a new field type for local time is coming soon. The time zone comes from the tablet so always good to make sure that is correct. Also the web map will sometimes show local time converted back. Timezones are really hard to get right. You may need to have a Arcade field ToLocal in the popup to convert it at the time of display.

kmsmikrud

Thanks so much and appreciate it on the testing. I'm a bit of an Island in our organization.

The table screenshot above was from ArcGIS Pro so the first few values in the AKCreationDate wrote with the 8 hour offset from UTC datetime which was perfect. I found that out on AGOL/web maps with the data displaying with local browser and its just easier on my part for processing data and dashboards to also have an AKCreationDate field.

Usually I would have python script tool that updates the fields (using the code below), but thought I would try to make use of the arcade calculated expressions this go around.

So one step forward but also backward if the data isn't accurate for what I intended.

 with arcpy.da.UpdateCursor(value, ["CreationDate", "AKCreationDate", "AKDate","ManagementArea"], 'OBJECTID = ' + str(oid)) as tbl:
                        for r in tbl:
                            utc = r[0]
                            arcpy.AddMessage(str(utc))
                            ak = utc.replace(tzinfo=pytz.UTC)
                            r[1] = ak.astimezone(pytz.timezone(AKzone))
                            r[2] = r[1].strftime('%m/%d/%y')

kmsmikrud

Hi @DougBrowning ,

I was curious how your offline datetime testing went with Field Map arcade calculations like using ToLocal? Thanks!

var akdt = ToLocal(Now())

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.