Convert Date to Text

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi!

I have a date field that is controlled by the customer. Any date can be added there (for example 2017-05-29).

Then I need a field in the same entity to look at this field and show the year and month but in text. So the example above should then show "2017-May"

How should I solve this?

regards,
Tomas

*This post is locked for comments

All responses (5)

Answers (1)

Suggested answer

Ryan Maclean 3,070 on at

Like (0)

Report

RE: Convert Date to Text

Hi Swede-T,

You could use the Workflow Elements solution by Aiden Kaskela to solve this https://kaskelasolutions.com/

Ryan
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report
RE: Convert Date to Text

Hi,

You can use javascript to do this.

var date =new Date(Xrm.Page.getAttribute('date').getValue()),
locale = "en-us",
month = date.toLocaleString(locale, { month: "long" });

Thanks...
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Convert Date to Text

You will have to write either JavaScript or C# (plugin).
Community Member Microsoft Employee on at

Like (0)

Report

RE: Convert Date to Text

Hi!

Ok so this is not possible to do without using java or functions?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Convert Date to Text

stackoverflow.com/.../get-month-name-from-date similarly you can get the year by getYear() method.