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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Calculating Lead Age
Customer experience | Sales, Customer Insights,...
Suggested answer

Calculating Lead Age

(0) ShareShare
ReportReport
Posted on by Rahul Soni 10

Hello,

I want to calculate the age of the lead in days.

We have a field called "Lead Age" as a Whole Number and calculated with formula - Set LeadAge to DiffinDays(Created On, Now())

This works with one issue.

The Time Zone that we use is GMT -5:00

Thus, as of 4th June 2020, the start of the day begins from 08:01 pm

Check attached image.

pastedimage1591287152900v1.png

Is there a solution ?

I have the same question (0)
  • Suggested answer
    Aga M Profile Picture
    Aga M on at
    RE: Calculating Lead Age

    Hi Rahul,

    Thank you for the question.

    In Dynamics 365 all dates are stored in UTC time and then formatted to user's timezone.

    2020-06-03 8:02 PM is already 2020-06-04 1:02 AM in UTC. So if you checked at the time when there was still 4th of June in UTC, the Lead Age would be indeed 0.

    Best Regards,

    Aga

  • cloflyMao Profile Picture
    cloflyMao 25,210 on at
    RE: Calculating Lead Age

    Hi Rahul,

    In Dynamics 365, Data in Date and Time fields is always stored as UTC, and date and time we see is formatted time(user local).

    For DIFFINDAYS function, if both dates and times fall on the same day, the difference is zero.

    In UTC, the first lead was created at 06-04 01:02 AM.

    What the meaning about "Thus, as of 4th June 2020, the start of the day begins from 08:01 pm"?

    It seems that your question was posted at 06-04 11:12 AM in your local time, so I think the time in attached image should be earlier than your posting time,

    and corresponding UTC time of Create On is 06-04 04:12 PM(value of NOW() function).

    https://www.timeanddate.com/worldclock/converter.html?iso=20200604T161200&p1=265&p2=211

    pastedimage1591327464798v1.png 

    You could check whether converted time(UTC) of time in the attached image is still in 06-04.

    Regards,

    Clofly

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 122

#2
DAnny3211 Profile Picture

DAnny3211 101

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 70 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans