topic Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range in ArcGIS Experience Builder Questions

Experience Builder - Filter Widget - Date "is between" allows invalid time range

AndyHodren1 — Thu, 11 Mar 2021 02:24:50 GMT

Experience Builder Version: 1.2 (running on ArcGIS Enterprise)

Hello,

I am using the Experience Builder Filter Widget with a date "is between" expression:

The problem is that a user is able to enter an invalid date range (start date is later than before date):

When this is applied, all data is filtered out. Is it possible to restrict users input to only allow valid date ranges?

Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range

TonghuiMing — Thu, 11 Mar 2021 03:05:41 GMT

Hi @AndyHodren1 - thanks for bringing it up. We will take a look.

Best,

Tonghui

Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range

DGer — Tue, 16 Mar 2021 14:29:20 GMT

I'm having a similar issue where my date filter filters out all of the data, even if there are dates within that range. Maybe there's a bug with filtering dates?

Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range

TonghuiMing — Wed, 17 Mar 2021 08:43:06 GMT

@DGer Is it possible to share your app and how you configure it for us to take a look?

Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range

DGer — Wed, 17 Mar 2021 13:23:50 GMT

Hi @TonghuiMing, thank you for the reply! I actually figured it out. Even though the column in the hosted feature layer with the dates registered as a Date field, there must have been some formatting issue in the date column in the underlying Excel spreadsheet. I deleted my date field in the Excel spreadsheet, created a new field, and then overwrote the hosted feature layer. After that it worked! Still not sure exactly what the problem was in Excel, but I must have fixed it by deleting the old column and creating a new one.

Re: Experience Builder - Filter Widget - Date "is between" allows invalid time range

BrittanyBurson — Tue, 17 Aug 2021 16:41:45 GMT

Thank you for posting this, I will be on the lookout as much of our data originates from Excel.