web

You’re offline. This is a read only version of the page.

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

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks so much! I need to pay more attention XD

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans