News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to calculate time ...

Microsoft Dynamics CRM (Archived)

How to calculate time between two fields Date type using JavaScript?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I have two fields Date type, i would like about how to calculate time among them 2 using JavaScript

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to calculate time between two fields Date type using JavaScript?

Thanks so much! I need to pay more attention XD
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to calculate time between two fields Date type using JavaScript?

My code

var dt1= Xrm.Page.getAttribute("new_date1").getValue();

var dt2= Xrm.Page.getAttribute("new_date2").getValue();

var h= Xrm.Page.getAttribute("new_hours").getValue();

var hours = 60*60*1000;

if (date1!= null && date2!=null) {

var diffHours = Math.round(Math.abs((dt2.getTime() - dt1.getTime())/(hours)));

}

h.setValue(diffHours );

------

but don't working
Community Member Microsoft Employee on at

Like (0)

Report
RE: How to calculate time between two fields Date type using JavaScript?

In addition to what Guido states, you'll have to take some other things into account...

What unit is your math in?

For the best accuracy, do the math in milliseconds as Guid's stackoverflow link suggests, and then convert to your desired unit.

With the two date fields in question, will they ever span a Daylight Saving Time change?

Check for this scenario and compensate when one date is in DST and one is not.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans