Filtering on Event Date | Community
Skip to main content
thomash82948276
thomash82948276
Level 2
Feb 1, 2019 3:08 PM UTC
Solved

Filtering on Event Date

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    New Participant
    Feb 1, 2019 6:22 PM UTC

    IIRC it’s ToDate().

    View reply

    3 replies

    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    New Participant
    Feb 1, 2019 6:22 PM UTC

    IIRC it’s ToDate().

    Translate
      thomash82948276
      thomash82948276Author
      Level 2
      Feb 1, 2019 6:01 PM UTC

      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

      Translate
      Jonathon_wodnicki
      Jonathon_wodnicki
      New Participant
      Feb 1, 2019 5:53 PM UTC

      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

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...