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)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (1)

Report

Hi,

you can "extract" the date components directly from the value.

You can use this code for example:

var dateFieldValue= Xrm.Page.getAttribute('datefieldname').getValue();
// create the yyyy-mm-dd string
var year = dateFieldValue.getFullYear()+"";
var month = (dateFieldValue.getMonth()+1)+"";
var day = dateFieldValue.getDate()+"";
var dateFormat = year + "-" + month + "-" + day;

Was this reply helpful? Yes No
NKC on at

Like (0)

Report

Thanks for your response but i want the out put as date( dd/mm/yyyy) format not in string. Thanks Any idea

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

Like (0)

Report

But after where you need to put the value as dd/mm/yyyy?

Was this reply helpful? Yes No
NKC on at

Like (0)

Report

I need to set that value to another date field, which i am using in a workflow. Thanks

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (4)

Report

With javascript you just need to create a new date a set to the field:

var dateFieldValue= Xrm.Page.getAttribute('datefieldname').getValue();
var year = dateFieldValue.getFullYear();
var month = dateFieldValue.getMonth();
var day = dateFieldValue.getDate();
var dateOnly = new Date(year,month,day);
Xrm.Page.getAttribute("new_datefield").setValue(dateOnly);

Was this reply helpful? Yes No
NKC on at

Like (0)

Report

Thanks indeed

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

how to set time also?

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Why add + 1 for month?

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

Like (1)

Report

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
PZ123 on at

Like (0)

Report

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