Hi all,
Recently got a request from field workers for them to be able to view a simple count of the amount of assets they had created for that day, as at the end of every day they need to report how many assets they recorded that day for billing purposes. I thought I would be able to make a simple Arcade Attribute Expression using the filter function that I could display in a pop-up.
I have looked at a number of posts on this site and tried to replicate what they were doing but haven't had any luck.
What I most recently tried was the script in this post: Solved: Today Filter with Arcade - Esri Community, but I was just getting error messages about the console expecting a long list of characters.
What seemed to get closest to any success was using something like this: Dynamic Date Filter - Esri Community, obviously with modifications because I'm not using JSON to filter a map layer - but I was getting a message that I had used the incorrect parameters to call GETDATE.
I'm a complete novice with Arcade and SQL, so I'm wondering if anyone knows how I could achieve a dynamic date filter that updates each day without user input?
Thanks.
