Filtering on Event Date

thomash82948276

01-02-2019

I'm trying to filter on Event Date in the Recipient Delivery Log.

My filter says: Include Event Dates that are equal to today.

1681441_pastedImage_0.png

When I do this, I get no records. 

I have confirmed that there are records with an Event date of today in the table; so I've discounted that as an issue.  I'm also using DateOnly as Event date is stored as Date / Time in that table.  That hasn't helped either.

Is there something I've forgotten here?

Thanks

Tom

Answers (2)

Answers (2)

wodnicki

MVP

01-02-2019

Hi,

Those are times, not days. Either truncate the right hand side so it’s a day, or use a range: on or after midnight prev day to before midnight filter day.

Thanks,

-Jon