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
Solved! Go to Solution.
IIRC it’s ToDate().
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
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
Views
Replies
Total Likes
IIRC it’s ToDate().
Views
Likes
Replies
Views
Likes
Replies