Getting only Date from Date time field using javascript

(0) Share

Report

Posted on by NKC

Hi i have field on CRM appointment form which is in Date time format, i want to get only date from that date time field, i tried few diffrent ways by using javascript either i am getting date in string format or date including time and jone(UTC). Any help please

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Ravi Fulani 834 on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

Hi Mohit, were you able to solve this part

Was this reply helpful? Yes No
Mohit Patel 25 on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

Hello,

I need to read Date value of one DateTime field in my Dynamics CRM Form using JavaScript.

I am able to read the value but it is not exactly same what I can see in CRM.

In CRM Form, selected value is: 17th May 2018

JavaScript Code return value as: Wed May 16 2018 00:00:00 GMT+0530 (India Standard Time)

CRM logged in user time-zone: GMT +10:00 Sydney

My time-zone: +5:30 India

JavaScript Code I am using is:

var dateFieldValue= Xrm.Page.getAttribute('MyDateField').getValue();

var year = dateFieldValue.getFullYear();

var month = dateFieldValue.getMonth();

var day = dateFieldValue.getDate();

new Date(year,month,day);

May I know how can I get exact date using JavaScript which I am selecting in DateTime control?

Thanks,

Mohit

Was this reply helpful? Yes No
PZ123 on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

Thank you Sir! You have saved the day!

Was this reply helpful? Yes No
Guido Preite 54,084 Moderator on at

Like (1)

Report

RE: Getting only Date from Date time field using javascript

because you are concatenating startDate and not dateFormat

the line should be

var concatedField = field1 + "-" + field2 + "-" + dateFormat;

Was this reply helpful? Yes No
PZ123 on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

Thank you for the quick response! I really appreciate. Your reply caused the code not break and work but it still is not doing what I want it to do which is retrieve the date only from the date/time "new_dateauthorized" field and set the value as mm-dd-yyyy. When I step through the code it sets the values right but when I hit continue and the code finishes it show the field like so:

name: field1-field2-Tue Jul 12 2016 00:00:00 GMT-0700 (Pacific Daylight Time)

instead of: field1 - field2 - 7-12-2016

using this code:

var startDate = Xrm.Page.getAttribute("new_dateauthorized").getValue();

if (startDate != null) {

var startDate = Xrm.Page.getAttribute("new_dateauthorized").getValue();

var year = startDate.getFullYear() + "";

var month = (startDate.getMonth() + 1) + "";

var day = startDate.getDate() + "";

var dateFormat = month + "-" + day + "-" + year;

Xrm.Page.getAttribute("new_dateauthorized").setValue(dateFormat);

ending with:

var concatedField = field1 + "-" + field2 + "-" + startDate;

Xrm.Page.getAttribute("new_name").setValue(concatedField);

Xrm.Page.data.entity.save();

Was this reply helpful? Yes No
Guido Preite 54,084 Moderator on at

Like (1)

Report

RE: Getting only Date from Date time field using javascript

maybe the field is empty, so the getValue result is null and you can't get the year.

try adding a check like

var startDate = Xrm.Page.getAttribute("new_dateauthorized").getValue();

if (startDate != null) {

var year = startDate.getFullYear() + "";

// rest of the code

Was this reply helpful? Yes No
PZ123 on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

I am trying this script to get the value of the date only from a date and time field in CRM. I used this but it doesn't seem to work. When I use the Developer Tools the script breaks on startDate.getFullYear() + "";

Any Ideas what I am doing wrong?

var startDate = Xrm.Page.getAttribute("new_dateauthorized").getValue();
var year = startDate.getFullYear() + "";
var month = (startDate.getMonth() + 1) + "";
var day = startDate.getDate() + "";
var dateFormat = year + "-" + month + "-" + day;

Xrm.Page.getAttribute("new_dateauthorized").setValue(dateFormat);

Was this reply helpful? Yes No
Guido Preite 54,084 Moderator on at

Like (1)

Report

RE: Getting only Date from Date time field using javascript

if you need to show the date as a string you need to add 1 to the month because in JavaScript the months starts from 0, if you need the date as datetime object you don't need to add

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

Why add + 1 for month?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Getting only Date from Date time field using javascript

how to set time also?

And how to set (createdon date only and 9PM)? Is it possible?

Was this reply helpful? Yes No