topic Re: Compare Future Date with Current Date in Arcade in ArcGIS Online in ArcGIS Online Questions

Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Wed, 08 Jan 2020 20:01:45 GMT

Hi,

I have a ArcGIS Online web map which has a feature layer (points) I created via Survey123. I have the feature layer symbolized based on the status (Not Complete, Complete, Follow-up/Reminder). The follow-up reminder status is the one I'm having issues with. This reminder status is set by the user via Surv123 and also has a date field associated with it. This date field contains the date that the user wants to be reminded on.

My goal is to have that particular point to display on the web map ONLY when the reminder date is hit. Today is Jan 8 and say the reminder date was set for Jan 10. Well I only want this point to show starting on Jan 10 and after that.

I was going to create the current date and time from Arcade with: Text(Now(),'MM/DD/Y hh:mm:ss')

and compare it to the reminder date via the layer filter in the web map. But this won't work as this Arcade field of current date/time doesn't show in the list of fields in the filter option in my web map.

Any solutions or better directions to take? Xander Bakker‌

Thanks,

Adam

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Wed, 08 Jan 2020 20:16:47 GMT

Hi joe rodmey ,

A couple of comments on your question:

If you want to compare dates, don't convert that to text. Use the DateDiff to compare them
I don't think filtering data based on an arcade expression is possible at this moment. Perhaps define a symbol that stands out when the date is met (or has passed).

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Wed, 08 Jan 2020 20:20:42 GMT

I'm comparing in filtering not in arcade. I cant have the points visible on the map as the field crews using the map on collector use it as a work to be done tool. If they see a point they will act on it. This is why i just want to "hide" these reminder points till when they are due.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Wed, 08 Jan 2020 20:35:15 GMT

Hi Joerodney ,

OK, cool... Have you considered Workforce to help guide your field crew to act on open assignments?

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Wed, 08 Jan 2020 20:36:31 GMT

Yes I have but It wont work because of certain limitations.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Wed, 08 Jan 2020 20:47:10 GMT

Hi Joerodney ,

Can you explain what those limitations are?

To use a filter, would require to have a physical field in your data, and that would require a scheduled task each night to update the field to filter on. This could be done with ArcGIS Pro scheduled task that will be available in version 2.5 to be released later this month.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Wed, 08 Jan 2020 20:58:05 GMT

Hi Xander Bakker‌,

There are a few of them but right now I'm not considering switching to another product. I just need a way to compare the reminder date with the current date.

Thanks

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Wed, 08 Jan 2020 21:39:47 GMT

Hi joe rodmey ,

Implementing Workforce would not mean switching to another product, but it would change your workflow by using this additional product. But I assume you have your reasons for not wanting to do this.

So back to the original answer; you cannot filter your data based on an Arcade expression. Just checked and this is not possible in the web map, nor in the new beta web map and neither when defining a hosted feature layer view. You will need a real field and this field should be updated (each night) for it to show the correct features. This will require updating that field each night in order to accomplish this. Field workers should refresh that data each morning to show this updates in their app.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Wed, 08 Jan 2020 22:23:04 GMT

Hi Xander Bakker‌,

What is your suggestion to perform these updates nightly?

Thanks

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Wed, 08 Jan 2020 22:39:34 GMT

Hi joe rodmey ,

I think it would be nice to use the new schedule geoprocessing tool, which will be available in ArcGIS Pro 2.5 (released later this month). You could implement a simple calculation comparing the current date with the scheduled date and set the scheduler to run every night.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

MarkBockenhauer — Thu, 09 Jan 2020 00:41:45 GMT

Adam,

An Arcade Expression like what follows.. should work.

var vstat = ''
var time1 = Date($feature.FollowupDate)
if ($feature.Status == 'Complete'){
vstat = 'Complete'
}
else if ($feature.Status == 'Not Started'&& DateDiff(Now(), time1, 'hours')<=0){
vstat = 'Future Follow Up'
}
else if ($feature.Status == 'Not Started'&& DateDiff(Now(), time1, 'hours')>=0){
vstat = 'Follow up Now'
}
else if ($feature.Status == 'Not Complete'&& DateDiff(Now(), time1, 'hours')>=0){
vstat = 'Still working on it'
}
else{
vstat = 'uknown state'
}
return vstat;

However, when I tried this in the Web MapViewer, the Symbol states would not generate?

My $feature.Status is a list (coded value) and I created a feature that met each of the desired states.

Was pretty sure this should work.. So, I tried it in ArcGIS Pro and... it works.

I set the symbols for future work and "unknown" to transparent. I also labeled all the points using a similar expression to "see" the future follow up features.

Using ArcGIS Pro I shared this as a webmap. https://www.arcgis.com/home/webmap/viewer.html?webmap=ddbd64b2302347d299cd62bce48ac242

and it also works in Collector. (did not try in Survey123.. but it should work)

If using ArcGIS Pro is an option for you... you can do it.

Mark

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Thu, 09 Jan 2020 14:27:05 GMT

Xander - I can't wait till that release

Mark - Thanks. I tried your arcade and was able to get it to work directly in the webmap. But I still cant filter based on arcade expressions in AGOL. I don't want the label or the symbol to show until the specified date.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

MarkBockenhauer — Thu, 09 Jan 2020 16:23:33 GMT

I labeled it, just to show that the feature is there and a symbol is not being drawn. You don't need show the label.

What do you need to do with a filter? I am not understanding that part. Or are you saying that using ArcGIS Pro is not an option?

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

SteveCole — Thu, 09 Jan 2020 16:39:51 GMT

I hope I don't confuse the situation but maybe this is an option. Recently, I wanted to use an Arcade field within the query filter for one of my webmaps but I found out that it isn't supported at this time (thread here). What I learned is that you can tweak the underlying SQL query using AGO Assistant and that's ultimately what I did.

In my case, I had a layer of deficient curb ramps but I only wanted to show locations that were scheduled to be repaired within the next 12 years. A wrinkle in my case is that the year field in the data I was given wasn't stored as a date object so I had to do some on-the-fly tweaking. Anyways, here's an example of the Query Definition that I swapped into the web map using the AGO Assistant:

(a5facilitycat = 'Curb Ramp') AND (m9upgradeyr >= EXTRACT(YEAR FROM CURRENT_DATE()) ) AND (m9upgradeyr <= EXTRACT(YEAR FROM CURRENT_DATE()) + 12 )

So, I'm just bringing this up since there might be a way to develop a more sophisticated SQL query outside of the Webmap environment.

Steve

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Fri, 10 Jan 2020 20:36:30 GMT

Mark - Now I need to show labels for only certain features. Is this possible with Arcade? I'm almost there. I was able to do this all in the webmap without bring it into Pro.

Steve - Thanks for the idea and ill keep it in mind if I can't get Arcade to work.

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Fri, 10 Jan 2020 21:00:13 GMT

Hi Joerodney ,

If the feature contains the information for the condition to decide whether to show the label or just an empty string, you can use Arcade to do this. What is the condition?

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Fri, 10 Jan 2020 21:10:59 GMT

Hi Xander Bakker‌

The condition to show labels would be "Status is not equal to Reminder"

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Fri, 10 Jan 2020 21:25:12 GMT

Hi Joerodney ,

And the text of the label is based on an attribute I assume?

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

XanderBakker — Fri, 10 Dec 2021 20:35:12 GMT

What you could probably do in that case is use the expression below (adapt it to your field names).

if ($feature.Status != "Reminder") {
    return $feature.LabelText;
} else {
    return "";
}
‍‍‍‍‍

("Status" and "LabelText" should be replaced with the names of the fields in your data)

Re: Compare Future Date with Current Date in Arcade in ArcGIS Online

joerodmey — Fri, 10 Jan 2020 21:33:05 GMT

Thanks I'll test it out