Forum Discussion

Maureen's avatar
Maureen
Helper III
6 years ago
Solved

Filter not applying correctly . . .

I am setting a filter on a date field in the query editor for after 12/31/2018 and it filters everything before 12/31/2018 but events on 12/31/2018 are not being filtered out.  Why is it keeping the 12/31/2018 observations?

 

  

Need Help
  • az38's avatar
    az38
    6 years ago

    Maureen 

    I think as you have a dateTIME type column it filters all data after 12/31/2018 00:00:00.

    set filter as after 12/31/2018 23:59:59

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Maureen 

    I think as you have a dateTIME type column it filters all data after 12/31/2018 00:00:00.

    set filter as after 12/31/2018 23:59:59

    • Maureen's avatar
      Maureen
      Helper III
      6 years ago

      I thought it was time too but I didn't see an option to enter time - just to select a date from the calendar.  I see now that I can type the time in after the selected date.