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 get time diffe...

Customer experience | Sales, Customer Insights,...

Answered

Segment get time difference between two date time fields

(1) Share

Report

Report

Posted on by Dibyajyoti Jena

Segment - I have a data source, which is having two date time fields.

1. Check in

2. Check out

Now I want to create a segment for all those customers whose checkin and checkout time difference is less than 24 hours.

Any suggestions how can we create the condition in segment to achieve this above scenario.

Thanks & regards,

Dibyajyoti

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

Comparison of two attributes is not supported in segmentation.
You can create a new column to store the difference between the /CheckIn/ and /CheckOut/ fields.
Then use this column to build the segment.

In my test, I built a custom column to store the days difference.
Then build the segments to find the customers with a day difference greater than 1.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Pallavi Phade 98

#2

Tom_Gioielli 81 Super User 2025 Season 2

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans