Filtering on Event Date

[thomash82948276]

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

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

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

[Jonathon_wodnicki]

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

[thomash82948276]

Thanks Jon

When you say "truncate the right hand side so it’s a day", what syntax is needed to do that exactly?

Many thanks

Tom

[Jonathon_wodnicki · Accepted solution]

IIRC it’s ToDate().