How to Compare two DateTime Fields

(0) Share

Report

Posted on by Screen one

310

Hello Everyone,

I have two DateTime fields i.e. TimeIn & TimeOut and I want to compare these two fields on the basis of "Time as well as Date" using JavaScript.

Please help..

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

Hello,

Check those links to compare two dates:

community.dynamics.com/.../compare-two-date-field-values-in-dynamics-crm-using-javascript

https://community.dynamics.com/crm/f/117/t/280706

Was this reply helpful? Yes No
Suggested answer

Kalpavruksh D365 CoE 2,545 on at

Like (0)

Report

Hi Manoj,

Please refer to the following link: www.digitalocean.com/.../understanding-date-and-time-in-javascript

Please mark this answer as verified, if helped you to resolve your issue.

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Hi Manoj,

On top of what Charles already suggested, you could consider using Business Rule too as they support some date time operators that might help

Business Rule

If your date time operations are a bit complex, you could also consider using a library like moment.js, please follow the links below if you are interested in knowing more about these

https://crmtipoftheday.com/398/careful-with-those-js-libraries/

https://gallery.technet.microsoft.com/scriptcenter/Momentjs-and-Dynamics-CRM-8bd3a264

Was this reply helpful? Yes No
Suggested answer

Antonio Lamanna 165 on at

Like (0)

Report

Hi, you can get the values from your two fields:

var timein = Xrm.Page.getAttribute('timein').getValue();

var timeout = Xrm.Page.getAttribute('timeout').getValue();

create new Date for your dates:

var inDate = new Date(timein);

var outDate = new Date(timeout);

compare variables:

eg. if(inDate == outDate) { ... }

var timein = Xrm.Page.getAttribute ('timein'). getValue ();

var timeout = Xrm.Page.getAttribute ('timeout'). getValue ();

Was this reply helpful? Yes No
Screen one 310 on at

Like (0)

Report

It Works ,Thank You !

Was this reply helpful? Yes No