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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / A field to show number...
Customer experience | Sales, Customer Insights,...
Suggested Answer

A field to show number of days a lead has been active

(0) ShareShare
ReportReport
Posted on by Logan W 87

Hi everyone, 

I found there is a timer field on the Lead to Opportunity Sales Process to show how many days a lead has stayed active.  Is there an out-of-box field?  

pastedimage1662018985955v1.png

Basically, I want to calculate and analyze two things

1)  how many days a lead has stayed active

2) once a lead is set to Closed (either qualified or disqualified),  the field just shows me the total number of days from the day the lead is created till the day it is closed. 

Thanks. 

I have the same question (0)
  • Ray Profile Picture
    Ray 1,537 on at

    Hi,

    I think the time is a out-of-box field "Duration" and this field is in "Lead To Opportunity Sales Process" entity. You may cosider to use it directly.

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 10,409 Moderator on at

    Hello Logan W,

    Yes we can,

    Please refer below article for it.

    docs.microsoft.com/.../leadtoopportunitysalesprocess

    Thank you,

    Amit Katariya

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,119 Moderator on at

    Hi Logan W,

    You can fulfil your requirement with the help of two approaches

    1. Approach # 1: As per my understanding, you need two calculated columns here
      1. End Date & Time (When record status equal to Qualified or Disqualified then et value to Now())
      2. Duration in Days (Something similar to End Date & Time - Created On)
    2. Approach # 2: Use timer control

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

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

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

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 June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Manoj - ManoVerse Profile Picture

Manoj - ManoVerse 77 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 45

#3
Chris1968 Profile Picture

Chris1968 20

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans