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.
Is there a solution ?
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
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
You could check whether converted time(UTC) of time in the attached image is still in 06-04.
Regards,
Clofly
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
