Filter not applying correctly . . .

[Maureen]

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?

[az38 · Accepted solution]

@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]

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.