Solved

Filter based off of date

  • 28 March 2018
  • 3 replies
  • 27 views

I have a list view and 2 calendar controls (start date and end date) currently set up on a form. When I try to filter the list based off of tasks that fall in the range, I can get results if my dates are different.

 

If I try to filter based off of 1 date, I don't get anything unless I change my calendar controls to DateTime controls. Is there any way for me to set up my controls or set up some rules so that all I have to do is specify the date and have it return everything that was started on that date?

icon

Best answer by evandberry 29 March 2018, 16:00

View original

3 replies

Badge +15

Hi,


 


Can you provide some screenshots showing how you currently perform your filter? For example, what filter did you configure in your rule?

Here's a couple of screen shots showing my Search button rules, as well as the filter for my search criteria



I got it figured out.

 

I created 2 expressions for my calendar controls. The "From" uses an expression that defaults the time to 00:00:00 AM.

The "To" calendar uses an expression that defaults the time to 11:59:59 PM. 

Reply