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

Question

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?

BrittanyBurson · Answer

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

DGer · Answer

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.

TonghuiMing · Answer

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