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 ...
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

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.