web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Segment based on dynam...

Customer experience | Sales, Customer Insights,...

Answered

Segment based on dynamic dates

(0) Share

Report

Report

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)

Many Thanks,
Elly

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

cloflyMao 25,210 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Regards,

Clofly

Was this reply helpful? Yes No
Elly-Farokhi 205 on at

Like (0)

Report
Copy link

Link copied!

you are amazing Cofly, thank you so much

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 129 Super User 2026 Season 1

#2

Jimmy Passeti 46 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans