web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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)
  • Verified answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Segment get time difference between two date time fields
    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
     

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans