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

Notifications

Announcements

No record found.

News and Announcements icon
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)
  • cloflyMao Profile Picture
    cloflyMao 25,210 on at

    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

  • Suggested answer
    Aga M Profile Picture
    Aga M on at

    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

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 137 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 57

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans