change date format on the field

(0) Share

Report

Posted on by Syed_Faisal

815

Hi,

I have created 2 fields. 1 set as "System Shipped Date" date only field and another 1 as "Warranty Status" calculated field.

Date format is showing perfectly and the requirement is need to change the display format on the field.

Instead of showing as 4/10/2018 it should show as April 10 2018

Please note this requirement is only for that field not for the entire system.

PFA

7206.Untitled1.png

Regards

Faisal

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (3)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello Faisal,

You can't change display format for one field. As alternative solution you can create "string" field and populate it with data format you would like to use through code.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Syed,

Sorry , Out of the box you can not change the date format for specific field in dynamics CRM

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi,

Can display the format using javascript code, as the field job just to Display the date ?

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Sayed,

Create a single line text field and in onload get the data from original field and change the format using JS and set the value to new field. Hide the original field .

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Goutam,

Could you help me with the code.

function ChangeDateFormat(){

Xrm.Page.getAttribute("new_warrantystatus").setValue(Date.now());

}

what could be setvalue ? Month Date Year

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

ok let me check will update in a while.

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

Here is code that you can use:

var d = new Date();

var monthes = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];

var result = monthes[d.getMonth()] + " " + d.getDate() + " " + d.getFullYear();

Xrm.Page.getAttribute("your customer string field").setValue(result);

Good luck.

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
Hi Sayed ,

Here you go -

function ChangeDateFormat() { var d = new Date(); var month = new Array(); month[0] = "January"; month[1] = "February"; month[2] = "March"; month[3] = "April"; month[4] = "May"; month[5] = "June"; month[6] = "July"; month[7] = "August"; month[8] = "September"; month[9] = "October"; month[10] = "November"; month[11] = "December"; var Month = month[d.getMonth()]; var Day = d.getDate(); var Year = d.getFullYear(); var datewithFormat = Month + " " + Day + " " + Year; Xrm.Page.getAttribute("new_warrantystatus").setValue(datewithFormat); }

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Goutham,

Thanks for the code, it is working absolutely perfect.

Regards

Faisal

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Goutham,

Code is working fine but we need to change something on the code.

Issue here is it is setting up today's date but we actually want the date which is already exist on the field only that format needs to change.

What is happening is, when we run the code the existing OLD date is also getting change and set to today's date.

Could you please help?

Was this reply helpful? Yes No