Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Filtering on Event Date

Avatar

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
thomash82948276
Level 2

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

01-02-2019

IIRC it’s ToDate().

Answers (2)

Answers (2)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
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

Avatar

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
thomash82948276
Level 2

Likes

14 likes

Total Posts

26 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
thomash82948276
Level 2

01-02-2019

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