Filter widget for attribute with Date/Time field > Ability to filter only by date?

[elpinguino]

Hi ExBers,

I am using the filter widget to filter by date. The date is originally a date/time field. In Map Viewer I've configured the layer to show just the date. However in Experience Builder when I use the filter widget it wants to filter by date time, so it's not easy to filter by one date. 

Have I missed an option to hide the time somewhere so I can filter by just date and not date time or do I need to reconfigure something before getting to Experience Builder and setting up the filter widget?

[JenniferAcunto]

In the SQL Expression Builder window, click the Choose input style button and pick the Date Picker option.

[elpinguino · Accepted solution]

Thanks Jen. That one was buried in there 😊

[MollyWalkner_1]

Hi @JenniferAcunto, this no longer seems to be an option for me in ExB. When using User Input, I can only choose "Today", "Tomorrow", "Yesterday", or Custom which is a predetermined date. When using Unique, I have to pick one date from my existing dataset. Either way, I'm not able to make this interactive for the user to choose. Am I missing a step to make dynamic date selections by asking the user? Thank you!

[D_Atkins]

Hi Molly!

Try clicking on the 'more input settings' button, then changing 'no user input' to 'ask for values'.  Then you'll be able to choose the input style (Date Picker or DateTime Picker).