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

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Segment based on dynam...
Customer experience | Sales, Customer Insights,...
Answered

Segment based on dynamic dates

(0) ShareShare
ReportReport
Posted on by Elly-Farokhi 205

Hello, 

I like to segment my customer based who submitted the form today only do you know how I can add this to query, here is my current filter:

INTERACTION(FormSubmitted, FormSubmitted_Contact)
.FILTER(FormId == 'xxx' && Timestamp >= DATE(2020, 5, 19, 0, 0))
.HAVING(COUNT() > 0)

Segment.JPG

Many Thanks, 
Elly

I have the same question (0)
  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,210 on at

    Hi Elly,

    You could set a moving-window filter to only consider interactions that occurred recently.

    e.g: The segment will find contacts who submitted a specific form in last 1 day.

    1184.JPG

    https://docs.microsoft.com/en-us/dynamics365/marketing/segments-interaction

    2318.JPG

    Regards,

    Clofly

  • Elly-Farokhi Profile Picture
    Elly-Farokhi 205 on at

    you are amazing Cofly, thank you so much

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 57 Super User 2026 Season 1

#2
Eugen Podkorytov Profile Picture

Eugen Podkorytov 26

#3
CU07021359-0 Profile Picture

CU07021359-0 23 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans