Expand my Community achievements bar.

SOLVED

Filtering on Event Date

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

IIRC it’s ToDate().

View solution in original post

3 Replies

Avatar

Community Advisor

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

Avatar

Level 3

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

Avatar

Correct answer by
Community Advisor

IIRC it’s ToDate().