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
Hi Mohit, were you able to solve this part
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
because you are concatenating startDate and not dateFormat
the line should be
var concatedField = field1 + "-" + field2 + "-" + dateFormat;
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();
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
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);
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
Why add + 1 for month?
how to set time also?
And how to set (createdon date only and 9PM)? Is it possible?
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,762
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
