web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Date attribute filter in Customer Insights - Journeys

(1) ShareShare
ReportReport
Posted on by 4

I have a journey that filters out contacts who are associated with an item where the associated date is in the past. The date field is formatted as MM/dd/yyyy.

In the segment I am using, all contacts should be associated with items that have a future date. However, the journey is filtering out approximately 20% of these contacts, even though their associated item has a future date.

I am trying to determine why these contacts are being excluded when the date associated with their item is in the future. Could this be related to how the date field is being interpreted or compared within the journey/segment?

  • André Arnaud de Calavon Profile Picture
    307,097 Super User 2026 Season 2 on at
    Moved the question from the Dynamics 365 General to the Dynamics 365 Customer Insights forum.
  • Suggested answer
    11manish Profile Picture
    1,423 Super User 2026 Season 2 on at

    Yes — date interpretation is one possible cause, but I would not assume that the MM/dd/yyyy display format itself is the problem. In Dynamics 365 Customer Insights – Journeys, the more important factors are the underlying Dataverse data type, time zone, time component, and how the segment/journey evaluates the related record.

    Based on the symptoms, I would investigate the relationship/multiple related records first, followed by Date & Time/UTC handling.

    If the requirement is simply:

    A contact should be included if they have at least one associated item whose date is today or in the future.

    then I would explicitly design the segment around existence of a related item meeting that condition, rather than filtering contacts based on whether a related item has a past date.

    Also, if the field represents a business date rather than an exact point in time, I strongly recommend changing/using a Dataverse Date Only column. This eliminates many unnecessary time-zone issues in Customer Insights journeys.

  • Syed Aqib Raza Profile Picture
    138 on at

    The MM/dd/yyyy display format itself should not cause this. Dataverse stores the underlying date value independently of the display format.

    I would first check whether the contact can have multiple associated items. If so, make sure the segment is checking for at least one related item whose associated date is in the future, rather than excluding the contact when any related item has a past date.

    For example, if a contact has one item dated 08/05/2026 and another dated 08/20/2026, the contact should still qualify if the requirement is "has a future item."

    Also verify whether the column is Date Only or Date & Time. If it is Date & Time, timezone/UTC conversion can affect comparisons around the current date.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 109 Super User 2026 Season 2

#2
Syed Aqib Raza Profile Picture

Syed Aqib Raza 88

#3
ParthPatel249 Profile Picture

ParthPatel249 84

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans